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.
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. They're stuck there, in that form, FOREVER. They're basically in Purgatory.