Just played through Ravenholm in HL2 again this afternoon. There were a couple pretty freaky moments there that made me jump. Good atmosphere in that level.
I heard for Episode 3 they were going to go back to trying to genuinely scare us again. though i wasn't scared during the HL2 games (though I will agree with you on Raveholm), I would like to see a good scary FPS, and i think HL and Valve can do it.