When you finally get to the end of the Dead Man's Switch campaign. You get a video from Sam (recorded long before his death) telling you about his twin sister, expressing concern that she's alone and regret for not being there for her. He then asks you to find her (confident that she'll forgive him because of her Catholic beliefs). By this point you've outed her as his killer (and possibly killed her or allowed her to die in revenge), partially motivated by her Catholic beliefs (to see her mother buried with all her organs).
Inside the Universal Brotherhood, one can find a letter from a member of the Brotherhood to his parents; In it, he explains that he hasn't received any letters from them, and so the Brotherhood must be right: They never loved him to begin with. Players who already know what the Brotherhood does to its members get an extra dose of Tear Jerker, plus some Fridge Horror when they realize that the Brotherhood is likely intercepting any letters that initiates would have received from their families.
Most of Dragonfall counts, really, as the creators went to deep lengths to show just how much a Crapsack World Shadowrun really is.
The Sim-addict, "Simmy" Kim in Kreuzbasar? Turns out that she got hooked on simulations because she'd miscarried, and was told she was infertile.
Simmy: Monika said I would forget. She thought the sims might help. In there, I'm strong. And I never have to lose anyone. But then I come back out... here. Where children play in the street, and I remember. Where I see Dr. Ezkibel, and I remember.
During Dragonfall, when you meet Feuerschwinge. This woman was once one of the most noble Great Dragons to exist...and now, she's a haggard, nigh-helpless Broken Bird at the complete mercy of the man who intends to kill her species. At that point, she isn't the Terror of Berlin anymore - no, she's its victim.