Alan Wake is all about building atmosphere, not really scaring you but messing with your idea of what you think is happening. It is not a horror game in the way some people think of them.
Better than I could have said.
System Shock 2 is really similar.