The Reveal there also makes an earlier series of events a bit of a Moment Of Heart Warming as well: Captain Heironimous Lex is the Gray Fox's worst enemy, totally dedicated to hunting down and wiping out the Gray Fox and the entire Thieves' Guild. To get him off everyone's back, the Gray Fox has you forge and deliver a letter recommending him as the captain of the Anvil city guard, in charge of protecting the Countess of Anvil. So in other words, he respected his worst enemy's dedication so much that he got him instated as the head of the guard in charge of protecting his beloved wife.
Chorrol's quests seem to involve heartwarming moments in some way (at least if you complete them with the correct endings). Rescuing a kidnapped girl and receiving her and her mother's undying gratitude. Recovering for the queen a painting of her late husband. Making sure that a man's two sons stay alive while trying to kill a band of goblins pillaging their farm, and seeing his relief when he hears of your success. Reuniting two brothers who had been separated since babyhood, and then helping them take back their family home. And, last but not least, nudging the captain of Chorrol's guard and an innkeeper to begin a relationship with each other.
Dar-Ma, the kidnapped girl, will greet you with "My hero!" about half the time as well. Given her sweet disposition and gratitude, mods where marriage becomes possible almost invariably include her as a marriage candidate.
The march to the fields of Bruma. You and Martin are finally taking the course of the crisis into your hands, and it takes a heart of stone not to soar when the townsfolk cheer you on.
If the Player presents the Sanguine Rose for the Blood of the Daedra quest, Martin is awestruck. While permanently giving up almost any Daedric artifact is a great sacrifice for the Player, this gesture is particularly significant after Martin reveals in dialogue that he had once possessed the Rose during his Dark and Troubled Past. Giving Martin the opportunity to destroy a relic largely tied to the guilt and shame he felt over the sins committed in his youth is certainly one of the kinder moments in the game.