Metal Gear Solid 3: Snake Eater (Playstation 2, 2004)
The Sorrow, one of the final bosses in the game, goes full Robert Smith and kills you by overloading you with the souls of everyone you’ve killed up to that point, resulting in the usual “game over” screen. Luckily, Snake has a revival pill, returning from the dead to realize that he’s been fighting a ghost. Spooky.