For some reason, the first thing that comes to mind is Mccoy's apartment from Blade Runner, with cute dancing dog and a balcony.
I'm not a fan of the game, but those moments felt so homey and relaxing.
And here's a candidate for the worst apartment ever:
