Amnesia and Silent Hill 2 and 4 are the only games that have really scared me a lot. Silent Hill 1 had great moments (the two locker scares are just awesome), but for the most part it doesn't come close to those three. I haven't played Silent Hill 3 yet, but I'll assume that one's good too.