Two games did it for me, more out of joy than sadness.
Chrono Cross was the first one. After everything I'd gone through in the game, everything all of the characters gave up, sacrificed, and all the people we lost, it was gratifying to conquer the final enemy, and see them all rewarded with...