The quarters on Deep Space Nine always seemed pretty spacious, actually. At least the senior officer quarters I remember off the top of my head. I feel like other people on the station had smaller quarters.
I think the two things I would definitely change if I were to live on the station are the triangle shaped pillows (boy, did they look uncomfortable) and the atmospheric grating lights that seemed to be everywhere. Looked cool on camera, but would be pretty annoying in reality, I guess.
I have to say, though, the beautifully large portholes looking out into Bajoran space would make up for a lot of those otherwise questionable aspects.