Both times mine gave me breastfeeding info, had a chat and explained what her role is. Never asked to see cot or anything like that. She also explained that if I wanted to she could explain safe consleeping practices.
It's really just a chat to answer any questions you have and see if you need any support before or when baby arrives and to give you your red book, which you'll need to bring with you when you give birth. It's nothing at all to be worried about. It's just so they can find your house and introduce themselves before the chaos is unleashed after baby arrives and you are exhausted and overwhelmed and can't even think about what you would have wanted to ask them.
I can't remember what we talked about with my first (it was a long time ago), but with my 2nd, basically it was just if I had any questions about safe sleeping, the early baby checks and visits, and we talked about what breastfeeding support was available locally and she gave me some good advice about things to try this time around (as I struggled with bf with my first).
They will also just generally assess if you seem okay and ask about any mental health concerns so they can point you towards resources (especially if this isn't your first and you had any PND, etc. last time) and make sure your house is safe and not a crack den. I've never had one want to see around or anything like that. If your lifestyle is truly chaotic (unstably housed, signs of obvious drug use, you have hoarded stuff that is stacked to the ceiling and causing a fire hazard), it will be obvious, but they'd really only flag that up if it was something serious, not if your house is a bit messy and you have a sink full of washing up.
Ours HV is other way round, we don't meet themuntil after baby is born and cleared by MW - we already know ours since we have dd1 and she comes in and laughs with us as house is upside down with washing etc (we have a small house) and toys everywhere.
Ours is lovely, very practical and mind get your Bookbug bag if in Scotland (not sure if England does it?)