A meta example, but during the launch party of Final Fantasy XIV: A Realm Reborn in Japan, director Naoki Yoshida shed Manly Tears after years of hard work revamping the game from the ground up while receiving a great amount of support from fans.
Everyone remembering you're a Warrior of Light in the ending cutscenes, if you're a Legacy veteran.
F'lhaminn reuniting with her adopted daughter, Minfilia, after being away from her for so many years while watching over her from a distance as her daughter grew up to be a successful and strong woman.
During The Three Collectors arc of the Hildebrand quests, we're shown that while yes, Hildebrand is an idiotic bumbling fool, his desire to help people with their problems is true, as he happily helps a the neglected daughter of an Ul'dahn noble woman with recovering a vase she had dropped while bringing home to avoid a monster attack. He helps get the vase repaired and restored by his father, Godbert despite his misgivings and disagreements with him over inheriting the family business, preferring to be an inspector. Despite failing to stop the thief from stealing a treasured sword, he helps the before mentioned mother and daughter connect via a good laugh caused by his antics.
The cutscene for "The Rising" anniversary event is definitely this, as another "meta" sort of example. The dev team, led by Yoshida and in the form of the Wandering Minstrel, takes the time to thank you, the player, for sticking with XIV through thick and thin. That they went through all that trouble, just to thank you, says volumes about how grateful they are everyone gave them a second chance.
The end of "The Beast Within" quest. After being stuck as a Tonberry and stirring in rancor for 1500 years, the Scholar who your fairy, Lily, originally belonged to could tell one another apart despite the changes. He warned her to stay away despite the rancor and tried to keep her safe by running inside so he didn't hurt her, and she stopped him from being killed and cured him of the hatred that left him tormented.