AnyFucker - yes it was horrible. We had to say for two nights and I hated every second.
Thinking about it now, if there was a time I would have wanted DH overnight it was in the days before our daughter was born, when we knew that if she was born she would die.
I was laid in bed in a private room, not allowed to get out of bed or even sit up, terrified that we were going to lose her and those nights were very long and scary. I had more than a few tears while I laid there in the dark making bargains with the universe to save her life.
At times I'd have chosen to have him with me then above any night in the ward with our healthy DS to take care of.
But even then, I don't think it would have been appropriate for him to stay from a wider point of view. I could have been there for weeks rather than days, nobody knew how things might turn out and at the beginning there was hope we could get her well past 24 weeks. A hospital couldn't support a partner camping out on the ward for an indefinite amount of time.
It was horrible on that ward with DS, and I couldn't wait to get home. But that was the most important thing for us. Yes it would have been nice to spend DS's first night as a family but it was far more important to us to know we would be leaving the hospital together as a family for the first time and not leaving without our baby again.