Very few games ever did well as a movie..
I'll echo some of the other responses and say that Resident Evil does an alright job as with the first Mortal Combat movie (The sequel was complete)
As much as I give my sympathy to the FF.TSW..It really did tank for me... Square really made an awful mistake.. But at least they learned a hard lesson about it.
Oh and Blood Rayne movie was so awful I couldn't watch no more than 20 mins of it.