Re: OOC
I don't think resurrection happens very often in the movies, but when it does, it is not always anti-dramatic, in my opinion.
In "Alien: Resurrection" they were able to bring Ripley back after hundreds of years via a cloning technique. This basically is equivalent to a magic ritual in Rifts as it would have been pretty costly, and it took a long time to perform.
In "Star Trek: Insurrection" (I think that's the one) Data sacrifices himself at the end and gets blown up in a ship. But not before he had the chance to download himself into another android.
Now, neither of the above cases resulted in a flawless 'resurrection' as Ripley came back with special powers and a lot of memory loss and Data came back with major memory loss. But they still came back.
So, I think most everyone would agree, resurrection should be rare and not generally granted to low or mid level player characters.