This Super Mario RPG fan sequel has a pretty disturbing death and game over scene.
mario gets shot by firing squad before the game cuts to his funeral with his friends and relatives crying over his corpse in an open top coffin.