Back to that old topic, the scariest game I played was Silent Hill 3, which uses psychological horror very well, I just don't wanna continue. Next was FEAR, interesting scares, certainly shocking at some points.

Spoiler Alert, click show to read: 
I'm talking about to early ladder scare in FEAR.
Spoiler Alert, click show to read: 
Not mentioning, these are pretty much the only scary games I played; I heard alot of other scary games.