Movies of games don't work for two reasons:
1. What will work as a game story and what will work as movie story are extremely different. Games are much longer than movies, and their interactivity allows them to have moments during play that in a movie would be extremely boring. Like say, Thief I, a game with an extremely good story, involves the player standing or crouching, waiting for things to happen, as much as half the time. This works in a game, because if you move into lighted areas or too quickly and noisily you'll alert the guards and get yourself killed. That creates suspense, because your character really can die during play. But the protagonist of a movie will never die except under very special circumstances, so you can't convince the audience that Garret should stay where he is for 3 minutes. They'd get bored out of their minds and walk out. So what do you do? Get rid of those moments? Make the entire burglary last 5 minutes? Wouldn't work; it'd look so unrealistic as to be pretty stupid. My point is that there are tons of things that games can get away with because they are interactive, and the stories written for these games take advantage of this. Which is why with most games, even the best written ones, when you try to adapt them to a non-interactive media like film you run into massive problems that are usually insurmountable.
2. Hollywood either doesn't understand how difficult it is to adapt game stories to two hour movie scripts, or doesn't care enough to actually try to make it work.