Some pretty great posts in this topic, well done, everyone.

Generally, in say a roleplay capacity, I'd put reversing deaths into the cop-out category. The death of a character should be something that's a huge impact,nt a temporary inconvenience. 

Look at super hero comics and movies and games. I actually had an issue from Spider-Man from like 97 or 98 that he died from long-term illness relating to the whole radioactive spider bite, and his cousin Ben (I think? I remember) took up duties as Spider-Man. Because none of you reading this knew about that, it kind of shows how big of a deal it was. It was like when he revealed his identity publicly during Civil War. They retconned that shit so hard it didn't matter. There's no lasting consequences in Marvel, and I am pretty sure they're going to bring Captain America back from the dead if they haven't already.

It shouldn't be used as a cheap emotional plot point that you don't stick by. If you aren't going to tolerate murdering your beloved character, just don't do it if you can't commit.