Please don't list this on a work's page as a trope. Examples can go on the work's YMMV tab.
Tear Jerker: LEGO Adaptation Game
The cutscene that plays after defeating the Emperor in LEGO Star Wars II. Nearly every other scene is played for laughs, but the death of Anakin and Luke's final goodbye to him are played heart-breakingly straight.
Gandalf the Grey, Boromir, Théoden...each major character death in Lord of the Rings is played very faithfully to its movie counterpart (complete with dialogue from the films), and they're all heartbreaking as a result.
All except one - when you play through Helm's Deep, you'll see Haldir duelling an Uruk-hai atop the wall. No matter how quickly you climb up there, the orc will kill the elf. Haldir doesn't have a cutscene, dialogue, or anything - he just dies during the level and there's no way to save him. What a Player Punch.
The fight with Mastermind, in the Statue of Liberty. He takes control of player characters one by one, with a screen in the background showing what he's forcing into their heads. While relatively angst-free Mr. Fantastic just sees himself fighting off a bunch of skrulls, Wolverine gets to relive the Weapon X experiment, and the Hulk gets to relive his birth as a giant green rage monster.
Wolverine: No! You can't turn me into a monster! I won't let ya!