I've play to this one few month ago, it's a really cool game, with nice and dark ambience...Action and horror/ambience are well balanced, not as in quake or doom...Try the demo, i guess that's exactly what you're exepting
yeah but fear is still more of a shootem up . you should look around for silent hill it may not be for the pc but as far as game play goes its EXACTLY waht your looking for.
Get Silent Hill 2/3/4 for PC. The first one is playstation only but the rest are on PC and they'de be what you're looking for. I'de say 2 or 4 would be best to get since 3 ties into the original where as the other two stand alone.
Also if you can find it get Nocturne, it's old but it had quite the creepy atmosphere.