I've never actually played the Silent Hill game, but the movie was one of the creepiest things I've ever seen. I don't know if the game is as creepy, but the movie certainly is not for the squeamish.
Another bad one: Parasite Eve. The movie had almost NOTHING to do with the game at all!