Depends. I'm playing through it now, and I'm about 2-3 hours in and I've had 0 scares through the majority of the game.
Also, a little off topic, I totally just watched Stephen King's "It" like...last night. Lol
Can't think if I've played anything that I'd class as scary recently. Condemned could be a little jumpy in places. Project Zero on the ps2 when that first came out was decent as well for scares. Nothing for me this gen though has really hit the spot. Alan Wake had its moments but was miss more often than hit, but that's all I can think of.