This is based on opinion. Please don't list it on a work's trope example list.
Tear Jerker / Grim Fandango
Meche's look of defeat after she dies is somewhat somber, but for those who have lost someone to AIDS or some other disease, it's absolutely painful to hear and see.
Meche: You're not the nurse...
Manny: ... No.
Meche: You're not here to give me my medication...?
Manny: No, but I am here to ease your pain.
Meche: Guess they couldn't save me, eh?
Lola's death/sprouting. Never mind she was a minor character who previously appeared in a single scene with something like five lines of dialogue. Never mind Olivia flat-out told Manny that she was doomed due to her crush on Maximino. The worst part is when Lola admits she developed feelings for Manny at some point, but figured out it was hopless due to his obsession with Meche.
Lola: Tell me, Manny. Would I have had a chance?
(Manny looks away.)
Lola: Never mind.
And it gets even worse when Manny discovers a clue she left for him at Toto Santos's scrimshaw parlor. Upon hearing her name, the normally antisocial Toto suddenly lights up and confirms that she visited him earlier, and the game never makes it clear whether or not Toto eventually found out the truth...
Toto: Sweet girl. Like daughter to me. Tell her Papa Toto says hello.
Manny: No, that was just for being you. I don't have time to get you for Lola, but I'm sure somebody will.
And again in Year 4 when Manny returns to Rubacava and revisits the lighthouse.
Manny:(sighing wistfully) Oh, Lola...
While most of the morally questionable stuff Manny has to do in the game is par for the course both for Adventure Games and the setting of the game in general, one moment in particular is very hard not to feel really guilty about: in Year 2, Manny has to drug one of Velasco's crewmembers, steal his identifications, and then hide them in an unidentified body in order to trick Membrillo into declaring him dead. Compared to the rest of the process, which is mostly comprised of comedy, Velascos' reaction to the news is surprisingly sad. What's worse is that both Toto and Membrillo refer to the sailor as "one of your boys" when talking to Velasco, implying he was A Father to His Men. Ironically, considering how Year 3 begins, Manny saved his life (and Velasco knows Naranja is still alive after Manny leaves.)
It's also the fact that Manny has deliberately misidentified a corpse, meaning that any loved ones that soul had will never hear definitive news about what happened to him.
Not the best example maybe, but Salvador's Heroic Sacrifice for some could be considered this. After everything the good man did to help hundreds of innocent souls get what they rightfully deserve, he himself never did.
The worst part? Salvador had earned a Number Nine ticket. Had it not been for Hector, he would have gone straight to Heaven and never had to look back. Manny's subdued reaction says it all.
Manny: Well, whaddaya know? Sal had a ticket all along.....
At the end of the game, Manny is finally free to travel to the Land of Eternal Rest with Meche by his side, but learns at the last minute that demons are unable to go there. Glottis may now be in the most ideal position a demon could be by that point thanks to Manny, but after four years of Undying Loyalty on both of their behalves, he and his best friend are forced to separate for eternity.
"You were the best boss... I ever had."
There's something sad in which Manny tells the Gatekeeper just before, "And, uh, demons ride free, right?"
In-universe, the story of beloved Sanspoof's death is so tragic that not even Manny, who normally detests cats, can resist getting choked up while he reads it. Every time the player looks at the photo finish card, the same sad music plays, capturing a moment in time just before tragedy.
Manny:(reading plaque) Beloved Sanspoof: This regal and majestic feline was a record-holder for speed, and a favorite of the crowds here in Rubacava for many years until her career was suddenly and tragically cut short on the second week of the racing season, when the airship Olivia 1, on its maiden voyage, crashed onto the track mid-race, and exploded. Many bereaved fans testified later that, before the blimp hit, Sanspoof... was in the lead.
Bowlsley. Poor guy loves flowers so much, he was a florist when he was alive. However, since here, flowers represent death for the dead, he's so confused. The thing he loves to do, which is sort and arrange flowers, is now considered a deadly shunned practice.