Dear gaymerbaymer, from what I've played in the past that does this is:
Away From Home - You and your mom sent away for your safety. Enjoy your mom, everyone else's Wife/GF.
Power Vacuum - You fight "Grandpa" for the girls of the family. Non-Canonical failures that don't count, still incredibly fun.
Desert Stalker - You fight and win, getting to enjoy people's loved ones for yourself.
Long Story Short - You get to enjoy your best friends' girl.
In a Scent - You get to infiltrate a family (Basically the backstory in a way, of Grandpa from Power Vacuum). Get to enjoy the family!
Thank you! Wish you a wonderful day as well.
Unfortunately, since I'm biased for good renders (3D mostly), this thematic is quite rare to find, similar to the theme of losing your girl to someone else, like:
Pineapple Express
Power Vacuum
Best wishes!