It seems to depend a lot on personal preference, and also your size comes into play. There are lots of good ones out there now, and like regular bras the more comfy ones tend to be less attractive/supportive. I always get some of each. I don't wear them at night because I don't leak so I don't need pads, at least I think that's the main purpose of sleep bras. If you fit into them, the Motherhood and Target ones seem decent and the price is right. They are good because you can see them in person. There's a million kinds online, too.
Follow Mothering