Say what you mean, mean what you say.
I would absolutely ask someone if they wanted a visit, whether thats my partner, my sister, whoever really.
I know a LOT of people who do NOT want visits or calls - they're not well, they're on lots of medication, they're in pain and don't want people seeing them like that, they're in and out for tests and may not even be on the ward, they'd feel more relaxed and able to get better knowing everything at home is safe and someones there in charge.
That in no way means I don't care about them or want to know how they're doing but the person in hospital comes before the person not in hospital.
When I am in hospital, as long as I have what I need, I am fine without visits for several days, after about day 4 I do start to get a bit bored of messaging vs chatting but again it depends what I am in for, how much pain, what meds etc.
There are also certain people I would want to talk to (via phone, messenger or in person) and certain people I would not. My best mate is the same - she'll happily waffle to me whilst off her tits on strong pain meds but definitely has other people in her life she would not want to talk to like that. She knows I don't care if shes talking total biscuits or falls asleep on me and doesn't get in touch for another two days... it's all good!
I'd talk to her, my partner, couple of other friends - I absolutely wouldn't speak to my sister until I was home as she absolutely pecks my head with her endless catastrophising!
Tell your husband how you actually feel. No good comes of expecting people to second guess or understand that some no's actually mean yes!