5. Final Fantasy X
Arguably considered an RPG cliché, the end of Final Fantasy X shows the main character, Tidus sacrificing himself. Pretty upsetting for the players as well as Tidus to find out that his entire journey through Spira was just a dream of the Fayth.
It doesn’t help the fact that the whole trip was chopped full of unfortunate events that Tidus has little or no control over, kind of feels like both the player and Tidus were just delaying the inevitable.