There is one instance in an RPG made by sega on the DS that came out about a year ago...
Sands of Destruction.
The whole game, we see that the main hero is a goody two shoes and a nice guy to an almost ridiculous degree. He is also the one who is destined to destroy the world, and anytime he tries to deviate from that path, his powers activate and he (unwillingly) blows up everything around him and turns it into sand.
So where does Protagonist death come in? Well, upon finding out that there is no way to be rid of his power, his party is attacked by someone who has been chasing them the whole damn game. And the hero demands/taunts the guy to kill him (so the world will be saved from his powers). That one act took a cliched goody two shoes hero, and made him way more interesting.
...Of course, they revive him later and find a way to use his powers to create, rather than destroy, but oh well...
The whole game, we see that the main hero is a goody two shoes and a nice guy to an almost ridiculous degree. He is also the one who is destined to destroy the world, and anytime he tries to deviate from that path, his powers activate and he (unwillingly) blows up everything around him and turns it into sand.
So where does Protagonist death come in? Well, upon finding out that there is no way to be rid of his power, his party is attacked by someone who has been chasing them the whole damn game. And the hero demands/taunts the guy to kill him (so the world will be saved from his powers). That one act took a cliched goody two shoes hero, and made him way more interesting.
...Of course, they revive him later and find a way to use his powers to create, rather than destroy, but oh well...