The only movie-based-on-a-game that had any fidelity to its origins was Resident Evil. They didn't set it in New York or L.A., they kept it in Raccoon City -- a dopey name but the right one. Because it was shot in Berlin it had a creepy feeling to begin but nothing about the production felt like Hollywood compromise except the inexplicable absence of Jill Valentine, who appeared (quite beautifully) in the sequel.
After the first 20 minutes or so Doom 3 was anything but scary; it was tired, irritating, predictable and cheated the player at every turn, particularly by making your character too frickin' stupid to use a flashlight and a weapon at the same time. Things popping out of the shadows where there were no things when you checked, unimaginative demons, a Hell that was little more than another boring level to find your way out of... Doom 3 was one of the biggest gaming disappointments since Daikatana. Its pitiful use of flickering light and perpetual darkness felt more like a Broken Monitor simulator than a game.
If you want creepy and disturbing (as opposed to simply scary) try any of the Silent Hill series. Best Buy is blowing out Silent Hill 3 for $9.99.
As for the Doom movie, chances of it sucking hard are extremely high but The Rock might have the charisma and charm to pull it off in spite of itself.