I'm enjoying the game I think it's pretty good for the most part, but it's simply not scary or tense at all. I found the intro surprisingly creepy and intense, but after that - nothing. I'll be wandering in pitch black surrounded by clickers and other infected and I don't feel anything. Whenever infected show up I just feel "Whatever. Great, there's more of them." A lot of the difficulty seems to come from trial and error too. If you don't approach things in the "correct" way then it's likely an instant death with no struggle or anything. I think that may be detracting from the horror as well. I am only 40% through the game though.
It's really weird that I genuinely do not feel anything during segments I think were meant to be scary. Siren Blood Curse took a similar stealth based approach to horror and that game scares the shit out of me.