For me, there have been some great scary games--or that is to say, some great concepts. Execution of which varied considerably...
1) System Shock. Deep, DEEP atmosphere combined with the classic "Who the hell am I, what am I doing here, and OMGWTF WAS THAT?!?" Conquering your fear as you...