This topic is to discuss some of your memorable game over title screens, deaths or sequences. It could be because of the art, the music, or anything about it that particularly sticks with you.
To get the ball rolling, I liked
Metroid Prime. It's pretty simple, but also pretty depressing, hated it when it happened to me:
Dead Space 2 has particularly gory death scenes, but to me, none were as hard to watch as the puker death
Persona 4 is great too, the piano is what makes it.