For anyone who thinks death penalty should exist but only with good investigation then you should check out a movie called The Life of David Gale to see how hard it can be. Also read up on a lot of US based appeal cases where someone who was innocent can get wrapped into a guilty plea or charge.
I dont see a need for it as I dont see it as a deterrent for criminals to commit the same crime in the future.