Only game where I actually got something out of the relationship, marriage, kids thing was Fable 2. Got married, got a big house, then ran around and adopted every kid the game would let me, and pretended that in fact my character was running an orphanage funded by their adventuring loot.