The first Condemned is really creepy. The end portions are freaky as hell. The 2nd game though... lololol MUTANT BEAR ATTACK lololol
For me the only games that really creep me out are Fatal Frame, Condemned, parts of Silent Hill (1's school, 2's prison), parts of Amnesia, parts of Penumbra. Siren is weird, I don't find it scary because the challenge of actually having to play well makes it feel more like a game. Whereas on the other side of the spectrum the lack of challenge in RE where you just kill everything your way makes it feel like a game as well.