IMO gory games aren't really scary, the really scary stuff is:
-Fatal Frame (try playing it alone with the lights off O_o)
-Rule of Rose
-Clock tower (get the first one if you can)
Yeah, for me it's these freaky games that's scary, the latest resident evil shouldn't even be called a horror game

too focused on action, no scary part at all..