I´d say super mario brothers (because it´s so bizarre while also hilariously bad) is one of the best alongside Mortal Kombat (the best of the lot), the first resident evil and House of the dead. Final Fantasy was also pretty good, and you could argue that it followed the spirit of the final fantasy, as they are known for having self-contained universes and stories, like the movie. And the story in the movie did feel a lot like a FF story, with the thing in the planet and all that. I consider it along the best film to movie adaptations, though it isnt exactly a masterpiece, it´s still a pretty good sci-fi movie, though nonsensical at times (just like the games...).
Kind of sad when you think of it, but considering what they have to work with, it isnt shocking that these adaptations often turn to shit.