I live in a small studio and have done for about 9 years. Primarily because the rent is cheap & stabilized (I pay less than $1000/month which is nuts for Manhattan) but also because I've really come to love living in a small, compact space.
a) Everything is within reach. I don't have to hike up and down stairs to get things, or indeed from room to room (unless it's something in the bathroom)
b) It's so easy to keep clean and tidy. Takes me about an hour and a half to do a thorough clean and tidy (dusting, sweeping, floor cleaning, all surfaces, bathroom, put everything away etc.
c) Because of the limited storage space I have to really think about what I need and what I don't need. There's no hoarding of crap when you live in a small apartment. Every year I find myself giving away or selling so much stuff that's outlived its usefulness, or that's been superseded by some bright shiny new version. I really love filling bags of things I don't need any more, then gazing upon clean and organized shelves and cupboards.
Girlfriend wise it's not ideal but then again my girlfriend doesn't live with me - if she did it would probably feel a lot more cramped. As it is she's over here most evenings and we have a great time without it getting too claustrophobic.
There are disadvantages to where I live, for sure. I have to think about the noise I'm making which means no midnight mixing sessions. And although it's the trendy East Village, technically it's a block away from the projects which means there's often hairy stuff going down, like the guy who got shot in the stomach around the corner a few weeks ago and ran into the deli downstairs gushing blood like a scene out of Goodfellas. But other than that I'm super-duper happy living in a cubicle.