Silent Hill 2 is the scariest game I have ever played(Resident Evil doesn't disturb me) The jail is so dark and gritty... very scary! My first time through I couldn't turn out the light.
Clock Tower didn't scare me all that much, but it was pretty creepy.
P.S. First post after a two week vacation!
