I enjoy the game, however it just fails to scare me (Only one game by far has been able to scare the crap outta me, clue- ghosts and camera =P)
the only part I ever squirmed was in resurection of evil when I was at a portal with a bruiser (big dudes with TVs for mouths) guarding it. The sound it makes when it stomps is full of suspense but then i realised i could use the artifact and sneak up on it with a BFG
And anyone who says that they can't beat the later half of the game, here's a tip. Get a chainsaw and crouch down for the rest of the game, EVERYTHING is easy to kill, except the sabaoth and the other two bosses, they'll turn you into mince xD