Please don't list this on a work's page as a trope. Examples can go on the work's YMMV tab.
Tear Jerker: Eternal Sonata
As the game is set on the night Chopin died (Yes, the real-life composer), you know it's not going to end well. But it's done so surprisingly beautiful that despite all of the Narm in the game up to that point, you'll still be crying.
Claves' death (sort of)
That's nothing compared to when Chopin dies and his spirit continues on to play the piano portion of the credits theme in the ending.
How about visiting the Elegy of the Moon? Just talk to all the souls who died from taking the mineral powder and try not to at least feel a little sad.
Not to mention, they're stuck there, in that form, FOREVER. They're basically in Purgatory.