What I really, really loved was the very first apartment in Vampire Bloodlines. It was a really tiny, a little run down flat in a tenement building. You had to know where it is since you didn't own the building or something. It was just your small flat right over a pawn shop.
What made that place really special though, is that a whole lot of stuff was happening there. And that's what made it magic. Not any potential customization options - but the TV and radio program that would change from time to time. The emails that were often not quest descriptions but instead interactions with characters (building back story and giving life to certain characters). It made the world feel alive - people were doing stuff while you are exploring town. There is really something going on and whenever you get back you're exited to see what news there are to be found!
I think it was that good because it felt like home. It was believable, cozy and alive - just perfect! Hell it even had a fridge and desk to store some stuff
If 2077 could capture that feeling - that would be pure magic! Ideally there would be even more activities there - imho it should be possible to sleep there (afaik that wasn't possible in VtMB). Also from time to time characters could come for a visit (maybe only after an explicit invitation? I guess it would be an unwelcome surprise to find someone you don't like in your one-room flat ^^)
Hah - now I hope the devs read this thread - because I would really love to see that!