This was the inspiration behind a campaign I ran once.
I had a bunch of new players, so I told them the intro session would be a 'guaranteed TPK' with characters I'd prerolled for them to introduce them to the game, combat mechanics, and character death.
Session 0 they're a bunch of elderly retired adventurers in a small village. At some point in their past they'd defeated a powerful necromancer.
Necromancer's daughter shows up to their village with an army of skeletons, combat's introduced, they all die semiheroically, cut away to a church to where the village children are huddled.
A lone cleric stands against the horde, Turning Undead and positive energy against undead is introduced, the cleric dies, the necromancess enters the church and realizes there are kids here.
She's here for revenge, but she's not cool with killing kids, so she creates an intelligent undead and instructs him to escort the children to the safety of a port town and leaves, not wanting to deal with this wrinkle in her plans.
Session 0 ends and I teach the newbies how to roll characters. They're free to come up with whatever backstories they'd like, but for those looking for inspiration: they have the option of playing as one of the saved village kids grown up (campaign takes place a decade or so later, varying maturity rates of the different races is blatantly hand waved) under the parentage of Bone Daddy, who broke free of the Necromancess' control a few days after the incident.