I dunno, it might purely be opinion, I must say that psychological terror can make me very tense and be like: "I'm so NOT going through that corridor!" Though the most intense scares for me were the suddenness of something scary. For example the movie Drag me to Hell, that movie gave me the largest shock I've ever had, not even a game has beaten it so far.
Spoiler in case someone is still planning to watch that movie:
Though yeah, in Dead Space's case, tension gets build up, and I must say, it is a bit of a party pooper... I mean, it's really like when the music starts building, I already know something scary comes and in my opinion, it risks being less scary.