My favourite "story" game in the Sims 3 involved a young witch who was the illegitimate daughter of a powerful wizard and his mistress. He didn't let her in the house, made her sleep in the shed and fed her scraps. I set some rules for myself such as:
She had to unlock the fireball spell to escape the shed at night
After she escaped she lived off the grid in the mountains near the town
She had to level up her handiness before she was allowed more than a campfire and a hay bale to sleep on
There were consequences if her father or one of his cronies caught her in town after she escaped
I created a new lot in the same town to be a prison and locked her in it at one point when she was caught
Whenever her teleportation booth went on the fritz, it was "her father trying to track her down", and she couldn't use it for a while
To win, she had to defeat her father in a duel
I had to use a lot of cc and cheats to make everything work though. I cheated to give the father 10 magic skill for example. I'm thinking of trying this again in the Sims 4 although I think it would be harder to set up.