One of my biggest dissapointments in the vanilla is the very limited number of player houses (well, two) and was wondering what the best selection of added mod houses would be?
I don't mean those homes that contain a personal armory and all kinds of absurd things- that's what I'd consider a cheat home at least- but something that will fit in with the normal game.
Are there any good suggestions?

Not really into houses that much (like to wander), but these caught my eye a while ago:

http://www.fallout3nexus.com/downloads/file.php?id=7115 - highly recommended!

This guy has a bunch of intriguing house/home mods: http://www.fallout3nexus.com/modules/members/index.php?id=356791 Some of them aren't quite what you're looking for (ie, laden with items) - quite interesting nonetheless.

:)