If I remember correctly the most favourably rated film based on a game where the story from the game was used was actually the first Mortal Kombat film, most other game to film transitions have been met very poorly:
Final Fantasy: The Spirits Within - was widely misunderstood and very few people took it seriously.
Resident Evil - had very little in relation to the games outside of the basic plot, and the genetically modified main character just didn't fit well with me either.
Tomb Raider - was so tacky to me I could almost see a tv series coming but didn't I think they'd be that stupid, then I discovered Relic Hunter and fainted in disgust.
Mario Brothers - didn't feel like any of the games at all, which is not surprising considering you'd have to do it as a cartoon, and kind of scewed off at a tangent after the main characters were developed.
House of the Dead - hasn't even been published in the UK (as far as I am aware) and only got good reviews from people who said "only watch if you're up for a laugh", which wasn't encouraging.
Street Fighter - the Anime one was good apart from the attempt at including every single character (all 16) oh, and the blatent shower scene, but the live action one, lets just not go there.
What I'm trying to say is, games turned into films, and (while on the subject) films turned into games, very often won't work out very well. You really need to get people making the transition to be fans of the original or people who would take the work seriously, otherwise it could easily be a half-hearted job because it's an already established copyright.
If they got the right people I definately think that these games could make very good films:
Deus Ex
Max Payne
Half-Life
Halo
Legend of Zelda
Flashback
Exile (BBC Micro game, now that's retro)
Diablo
Postal 2 (if done right, this could make a hysterical film)
On the other hand, here're a couple films that might make good games if done right:
Borne Identity
Avalon (the one from the guy who did Ghost in the Shell)
Avan
[edit] I went it bit OTT on the info there, didn't I?
I don't suffer from insanity:
I enjoy every minute of it!
