How about Oblivion or Skyrim? Those games have some pretty twisted stuff in them. Happen upon an abandoned lighthouse, come to find out the entire family was murdered by a rat one by one, and you get to read all their journals about it. Not to mention cannibalistic families and all sorts of other dark situations throughout the game.