I......thought I posted this here....I guess not? ANYWAYS.
As a young kid playing 'Link's Awakening', the game messed with my mind by having the Bosses warn that waking the Windfish will kill everyone. Nearing the 3/4 part of the game, it's confirmed the world around you is just a dream for an elder god. That kind of revelation and the shit I was going through made me feel ridiculously bad, and I had to put the game down for a long while. Looking back now though, I love the story that was set up for that game and it's one of my most favorite Zelda games.