Shoot the Shaggy Dog/Tabletop Games


 * Most of the games in the first run of White Wolf's Old World of Darkness setting were gigantic exercises in Shooting the Shaggy Dog. The good guys in each setting were gradually (or abruptly in Hunter: The Reckoning) revealed to have a long and unpleasant past of doing rather nasty things in the name of the cause, and the series of epic centuries-long secret wars they were fighting generally tended to be either unwinnable stalemates or tragically doomed noble causes. And most of their problems turned out to be caused by the arrogant hubris or ignorance of their own predecessors anyway. And to top it all off, the entire original setting had a series of apocalyptic end of the world scenarios as its grand finale.
 * Paranoia. It's essentially a game that states, in the manual, that every game should be a (funny) shoot the shaggy dog story.
 * In Call of Cthulhu (tabletop game), mythos monsters (and more mundane horrible experiences) make you lose "sanity points" and you gradually go insane. You get back Sanity Points by defeating monsters, which often require either magic or better weapons than the players have to kill. However, spells also cost Sanity, and most spells cost large amounts. If you don't go insane, it's all right, because most monsters can kill you anyways. However, it is justified by the fact that it is based on Lovecraft's equally bleak books of the Cthulhu Mythos.
 * If you want a bleak RPG where A Fate Worse Than Death awaits and failure (and death) is often the only option for characters in the long run, try Delta Green (which is basically Call of Cthulhu meets secret society Special Ops).
 * Kult, a Swedish roleplaying game with its gloves off, the setting of which can be summed up as "Splatter Punk, Cosmic Horror, Mind Screw and lots of Squick". In Kult you can sort of "win", and become an Eldritch Abomination that you were before the Demiurge trapped you and the rest of humanity. Of course at that point there isn't exactly much left of you as you were as a human.
 * Honestly, how do you think it's going to end in Warhammer 40000.
 * End?
 * Don't Rest Your Head is made of this Trope: literally every game mechanic represents a different gradual (or rapid) slide of your resources dwindling away, as your life becomes more and more a nightmare. With a little luck and a kind GM, you may manage to save whatever is most important to you as you are destroyed in the process. If not... then this trope.