Alone in the Dark was pretty much the first Survival Horror game ever made, and it remains one of the best. Though I agree; I would live in Silent Hill if I could. Actually, I know that at least the first Alone in the Dark is freeware now, and you can download the full version here:
http://www.abandonia.com
Unless your OS runs DOS apps well, you're going to need to download DOSBox. Also, some knowledge of the Lovecraftian mythos is strongly recommended.
I'm not usually a fan of game-movie adaptations, especially knowing that it's going to be done by the guy who did House of the Dead, and judging from what I've seen, the movie has nothing to do with the games. But I guess time will tell.