Death sucks. Loose ends don't get tied up, your family fights over your last possessions, not to mention the whole 'oblivion' thing. But somehow, a video game death seems worse - because at least with real death, you won't be around to see people openly mocking your failures.
It's one thing to use a game over screen as a way to persuade you to give a level another go. It's another entirely when a game goes out of its way to berate you for your inability to press buttons with the right timing. Sure, our family and friends might be doomed, but we don't need to see their desecrated corpses lying in a heap to know that we should give it another shot. These are game over screens that hit just a little too hard.