Omg Silent Hill 2... I am so amped for the remake!! I never really got into Skyrim, the story of Oblivion eas much better IMO, but I'm a graphics snob and just can't play it now... I have tried.
Comfort games for me are ones that are more focused puzzles and riddles than tons of fighting... I get completely overwhelmed with tons of things trying to eat my face off, ok! But, I do enjoy spooky vibes, so... The Sinking City, was amazing for this (and I am do excited that it's getting a sequel). I also loved most of the Sherlock Holmes games (after they stopped being point & click), I haven't played the newest one yet, but I have it. The only real exception to the fighting thing is GTA V(online), there is nothing more soothing then getting on and just killing loads of NPCs for no reason other than you can.