Regardless of his gripes, many of which do have merit, it's still a fine game. It's "survival horror" not straight up horror. It's supposed to be in your face and sort of tense. I mean, let's be honest here, how many games have been geniuely scary over the years? I can think of....three: Silent Hill 2, Penumbra(both games counting as one together), and Amnesia: The Dark Descent.
Sure, some games have had scary moments, like Half-Life 1 and the other Silent Hill games, but most games aren't outright scary. Those three are scary because they don't try to be "slasher movie" scary, but "The Exorcist" scary, in which they fuck with your head and give you extreme paranoia. For example, in Silent Hill 3 I remember a scene where you walk into a small room, and find a diamond necklace around a mannequin, but it has no clasp and is too short to get over the mannequins head. So you start to walk out, hear a scream, and go back. The mannequin's head is now gone and there is blood all over it and the walls. Okay, that's pretty damn creepy, but most scenes before that are OOGA BOOGA BOO type shit. Compare that to Silent Hill 2, when you are being stalked by an unkillable beast of a man in Pyramid Head, and near the end of the game you discover there are two of him, and you can't kill them. Instead, they up and decide to kill themselves to let you proceed. Or just the much subtler bits that baffle you and freak you out, like the legendary graffiti "There was a hole here. It's gone now."