I don't think I've ever heard of or seen a good game-based-movie. I'm sure it's possible, I just haven't seen any.
Book-based movies can be quite good, though. Such as Hylian Hobbit mentioned, The Lord of the Rings, Chronicles of Narnia, etc.
Books are usually always better, therefore...