Please don't list this on a work's page as a trope. Examples can go on the work's YMMV tab.
Tear Jerker: The Legend of Zelda: Link's Awakening
The whole island is revealed to be part of the Windfish's dream, and when you wake him up so Link can leave the island, everyone you got to know in the game blinks out of existence - with the scene hanging on Marin singing for a few moments before ending. Put this together with the realization that the monsters attacking you were pretty much just trying to keep you from destroying their home, makes this a fairly depressing game.
And the music that accompanies it, the Ballad of the Wind Fish... it's so... melancholy. (Listen to it here; the actual ending is more embellished, but the melody is so... haunting).
And your very last image of Tarin? Is him beaming and holding up a mushroom as he slowly fades out of existence.
Though if you beat the game without dying (not even once!) then Marin turns into an angel or a seagull, depending on the version, at the end instead of disappearing into nothingness.
Think about this one for a minute: After love interest Marin realizes that Link is going to leave the island, and some hinting that perhaps she had even realized the true nature of her existence, her only request was for Link to never forget her or her song. The character has never appeared or even been mentioned again in any other Legend of Zelda game. Ever. Neither has the song.Twilight Princess' ending doesn't really compare to being obliterated AND forgotten. Moreover, the song you use to wake the Wind Fish and erase the island is the love song that she taught you. Nothing can escape from the black hole of hopelessness that is this game's ending, except maybe a seagull.
A song bearing the same name is played in Majora's Mask, but is otherwise unrelated to it.
And Majora's Mask is set in an entirely different timeline in which Marin didn't even exist in the first place.