This is based on opinion. Please don't list it on a work's trope example list.
Tear Jerker / Call of Juarez
The opening of the last chapter of Call of Juarez: Bound in Blood. Ray and William corner Thomas and Marisa in the vault, with the elder brothers eager to kill each other. Willaim finally steps between them, threatening to kill Ray if he doesn't stop. He reaches into his coat... and Ray guns him down. Turns out he was reaching for his bible.'' The game then seems to have a hopeful ending... until you remember this is a Prequel, Thomas will become an abusive parent to Billy, he and Marisa will be murdered twenty years later, and Ray's Faith Heel Turn will only make him an even bigger monster before he dies.
The final scene in the "good" ending in Call of Juarez: The Cartel where Ben places a rose on the grave of Patrick and Jessica Stone while somber music plays