Of allllllllllllll the games to movies made (which isn\'t much), the only one that I enjoyed were Resident Evil (and I said I enjoyed it. I didn\'t say it was a great movie), and Tomb Raider (same critia as the Resident Evil movie. Enjoyed it, but not a great movie). Final Fantasy too but this one isn\'t really based on any games, just the name was taken from the games. Haven\'t seen Mortal Kombat, but my understanding is, its at least in the same league as Resident Evil which means, like it or really hate it. None have ever been truely great at the moment (Resident Evil: Apocolypes looks promising, House of the Dead looks stupid [trying to recreate that B-movie feel apparently with mixed results], and Alone in the Dark...well, it has some big names in it...but thats not saying much since the movie could still suck [Street Fighter had some big names in its day, and it sucked big time]).
As for Silent Hill movie, so far, with Konami having a ton of control, and a director that looks like he knows what he is doing (granted, I haven\'t seen Brotherhood of the Wolfs, but I have heard positive things about this movie), the movie does sound promising.