The temporatory state of death in comics

I'm a pretty big DC fan, and they are notorious for killing and bringing back characters, such as Superman, Jason Todd (Batman's second Robin), Bruce Wayne, and more.

Warning: Jason Todd spoiler ahead...

I didn't like Jason as Robin (who he died as), but love him as the Red Hood (who he became after his resurrection). I didn't vote, but I would've in favour of killing him. So I'm pretty torn on his resurrection. His death is one of the single most impactful storylines in the Batman universe (another being Barbara's spine, which might be worth its own discussion...). It changed Batman, how other heros viewed Batman, generally changed the feel of the safety of pretty core characters for the reader. And I wanted to keep all that. I liked that Batman that has to take responsibility for putting a child in danger and getting him killed. I liked that shadow that Jason's death cast on the Bat family and the way it haunts them.

However, I really enjoyed Under the Red Hood, and it remains one of my favourite arcs. And in the new 52, the mending of Jason's relationship with Bruce, and the other Robins. He's the black sheep that works great to contrast Batman (Bruce and Dick's).

Though I enjoyed the stories that are only possible through resurrection (or rebooting), I can't help but feel it takes too much away from the original story, and in many ways disrespects the original work and its reception. And what use to be a devastating turn in plot, is just an almost ridiculous trope.

How do you feel about resurrections in general? How does it change when the stories are supernatural? Any other Red Hood fans?