Please don't list this on a work's page as a trope. Examples can go on the work's YMMV tab.
Tear Jerker: Mystery Science Theater 3000
There's something oddly sad about the show's closing theme. It's a slower-paced version with an emphasis on regal-sounding brass, as though it's some sort of wedding or funeral procession, until about halfway through when the rest of the "ensemble" kicks in with a nearly heavenly sound before closing with the familiar "twang" of the original theme. Especialy if you're a fan of the show, it's likely to bring a tear to your eye.
In the final episode ("Danger: Diabolik"), while using a joystick to control the SOL, Pearl accidentally breaks the control and sends the Satellite of Love spiraling down to earth. Realizing that all of her experiments have failed, and there's no way to continue, she has a massive Villainous Breakdown, throwing her rage around the castle. When we cut back to her, her mascara has streaked down her face in tears, and the actress playing her really does look like she's upset about the series ending.
Word of God: Both Mary Jo Pehl and the rest of the crew all confirmed that she was hit the hardest by the cancellation. She also did the final ever filmed scene of the series, when she (cruelly) is forced to tell Mike and the bots, "Look, Nelson! Move on... I am!"
The final shot of Mike, Crow and Servo riffing a bad movie, this time at home, with no one forcing them to. Stockholm Syndrome? Maybe, but Word of God said that they were simply emulating what everyone does during a bad movie. And of course, realizing it's over.
Gypsy at least becomes the CEO of ConGypsCo. Mike and the 'bots were offered shares, they passed, which is why they're living in a the basement apartment of an efficiency in Wisconsin. They still think it's "sweet living".
Despite the disturbing lyrics, Forrester's "Who Will I Kill?" song after Frank ascended into Second Banana Heaven is a huge one.
Basically, any time Joel, Mike and the bots come close to being utterly broken by a film. Examples include Manos, Hobgoblins, Red Zone Cuba, Invasion of the Neptune Men, Monster a Go-Go, and the most severe example of the film nearly breaking them, Castle of Fu Manchu.
The short "Catching Trouble", about a man named Ross who hunts down and captures wild animals for zoos and to sell as exotic pets. Seeing the animals crying out in fear as Ross manhandles them, throws them into sacks, and drags them away from their homes is really heart-wrenching, even with riffing.
In the final host segment of Santa Claus, Mike exits the theater alone and starts singing I'll Be Home For Christmas softly to himself. This was not too long after Mike had been trapped in space and in that moment you realize the reality of being away from his family during the holidays is really getting to him.
Servo's song from "Gamera", Tibby, Oh Tibby, though played for laughs, can come across as incredibly sweet and heart wrenching, especially to those who have had pets pass away.