Finished F.E.A.R. 2 earlier.
Not scary at any point apart from the end sequence before the credits.
Why? Because whilst you're running about hitting switches in this hallucination you're having you need to fight off one of your team mates ghosts, not to bad. During this process though you flash back to reality every now and then to witness Alma raping your character.
Then right at the end after that, she pops up, magically 9 months pregnant and makes you feel the bump.
Shit was fucking disturbing.

In case you don't know who Alma is by the way, she's a dead psychic bitch who was strong enough to keep terrorising people after she'd died. IT WAS FUCKING HORRIBLE.