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 Longest Journey
White Mother's death.
When April sleeps in the Banda village and at night her Evil Twin who is really just a projection of her worst fears appears and belittles her to the point of despair, a projection of Charlie appears and tells April she is not alone on her journey and is loved.
There wasn't one particular moment that this troper can remember, but the entire atmosphere of the second half of the game, when April is risking life and limb in a quest where her reward would be to shut herself off from the entire world for centuries, with no one she'd ever met knowing what had happened to her to be phenomenally depressing.
This troper can remember one: the last scene, in which the old Guardian shrugs at April and essentially says, "Oops! Our mistake, you can go home now. Thanks anyway." After all the time spent telling April she's important to the fate of the world(s), it's a Player Punch to see her dismissed like that.