Siren Blood Curse is really scary, maybe even the scariest game I know.
But I played it through anyway. The story is so weird that you just have to see the ending.

Silent Hill 3 have some spooky moments to. Especially the moment in the closet when the mannequins head fell off.
The scream scared the hell out of me.

Doom 3 is also scary.