Please don't list this on a work's page as a trope. Examples can go on the work's YMMV tab.
Tear Jerker: Glory of Heracles
This is one of those "smiles and tears" series. Your party will have some good times, but the story can hit YOU hard when you least expect it.
Just before the last battle of the DS game, the party is walking towards Typhon and the floor shatters. It's too far to jump, so Daedalus throws the protagonist. Before his floor gives way and he falls to his death, he gives some pretty heart-wrenching lines to the protagonist
Daedalus: Hey, you! My little reanimated doll! Will you quit trying to fly! Keep your feet planted firmly on the ground! <pause> Wait, I take that back. Your fate is your own, and I can't change it. Live your life as you wish.