I have never been a fan of spells like Raise Dead or True Resurrection. In the past, I removed these from my games because I thought they minimized death's impact. How do players fear character death if they know they can cart their corpse down to the local temple and be up and walking again within a few hours? They don't. Removing simple magical means of resurrection presents its own problem: how does one return to the land of the living?
The DCC RPG recommends handling this matter with a quest. I think this is the right method. I've also been reading up on the megadungeon and am looking to combine these two ideas. I can't say too much right now because I'm still in the very early stages of figuring out what I want to do, but I will be working on this a lot in the coming weeks as one of my players lost his favorite character last session.