I like this, but couldn't XP it.YThe biggest problem with the Raise Dead spell that Mr. Cook doesn't even consider changing is the simple fact that it completely undoes death.
<snip>
People like raising the dead because it lets them to continue playing with a character who died. People dislike raise dead spells because they undo the story aspects of death. The simple solution is to both let the character come back but not undo the story aspects of death. In other words, a character who was raised from the dead is still, in some sense, dead.
Raise Dead spells should grant a temporary reprieve from death and are ultimately more akin to necromancy, rather than "curing" death and being equivalent to healing magic. A character who died once is doomed to return to death. They become detached from the reality of the living. After the campaign is done, they will simply return to the land of the dead
The more rose-coloured version of this, and of TwinBahamu'ts suggestion, is the 4e version - that only certain souls are fated for heroism, and those are the ones that the Raven Queen will permit to return from the dead.I think dark, dangerous side effects would be a good method for keeping the normal men from tampering with mortality.
So tampering with mortality is a sign of some special doom or fate, but it's grimly heroic rather than darkly necromantic.
A modular D&D might even put forward both options, reflecting different underlying campaign tones.