Sorry to keep beating the horse and all, just wanted to clarify. Of course it's possible to do a scary game in a first or third person way, in a more shooter-type environment...But it's much more difficult to do that in the Silent Hill world, because there's so little action. It's all atmosphere, right? Those games you mentioned were great though (Though I never played System Shock 2 or AvP 2, regrettably) and definitely scary They just aren't scary the same way Silent Hill is, at least to me. It's all very subjective
Just saying that, if you wanted to create a Half Life 2 mod that mimicked Silent Hill, it could be great - but it couldn't be a straight-up shooter. The pacing would have to be slower (Not literally, like with bullet-time, hehe), and there'd have to be a MAJOR focus on atmosphere.
That's some difficult stuff to pin down right there, and Silent Hill itself does it so well, which is a big reason we all love it. Duplicating that in any other medium would be so painstakingly difficult
On that note, strangely enough, I heard someone on the Elder Scrolls IV: Oblivion forums the other day request Pyramid Head be modded into the game...which would be cool, even though there's no way he'd fit!
Ohh...reminds me. There's actually a real review up on the movie now, at The Horror Channel. I don't think there's any spoilers in it, but it was actually a very good review, with 4 1\2 Mugs of Blood outta 5! Have a look!
The Horror Channel Review: Silent Hill
The Afraid of Monsters mod for HL1 matches the mood of Silent really well. It was inspired mostly by Silent Hill. Worth a playthrough.
http://www.planethalflife.com/features/motw/aom.shtm