All those games sound epic - I love a good epic story with a bit of fear.
The scariest game I've played is Twisted Metal Black for the PS2, not so much the gameplay, but each of the characters have their own back story and their all so... Twisted *shudder*
I recommend it for anyone who loves really gothic, crazy, car chases

Either Dead Space or Slender The Arrival