The old Sega RPG "Phantasy Star III" has an interesting gimmick where at 2 points in the game, you choose a unique wife thereby creating a unique offspring who then becomes the new protagonist in the following chapter. Is there another game that has done anything similar?

Its really cool. If I remember correctly, you get to choose between 2 wives. A unique child is then formed and flash forward to that child being the new adult protagonist in the next chapter of the game. Then at some point that unique child gets a choice to wed between different women and creating a unique grand child. And it wasn't simply cosmetic, they had unique abilities based on their parents. I thought this gimmick was brilliant and curious if any other game has anything like that?