As for what I consider to be the best film based upon a video game, I vote for... *drum-roll* Paul Verhoeven's Starship Troopers, which I view as a satire of war time propaganda (albeit unsubtle, ultra-violent satire seems to be one of Verhoven's greatest strengths, as per his RoboCop).
As for what I consider to be the worst film based upon a video game, I vote for... *drum-roll* the bulk of Uwe Boll's filmography! Okay, if gun-to-my-head I'm absolutely forced to narrow it down to a single film as the worst of the worst: I'll vote for House of the Dead!
Certainly, it does seem as if cinematic adaptations of video games tend to be bad more often than not. As such, I immediately have apprehensive reservations and low expectations whenever I hear word of another adaptation (such as NetFlix's recently announced The Legend of Zelda series) in the works.
However, although there may not be a strong precedent for quality film and television adaptations of video game based material (to make quite the understatement): the mere lack of a precedent by no means precludes the sheer possibility of creating a quality film or television adaptation of video game based material (although it certainly suggests a strong historical unlikelihood).
It is not entirely out of the realm of possibility that the film and television industry may eventually learn from their mistakes with respect to adapting video game based material and start producing higher quality adaptations--as they eventually did with their adaptations of comic books. (And if higher quality productions were to be produced, it would be adaptations from quality games providing source material sufficiently rich and developed to lend itself to a quality film or television adaptation--ones that moreover have a sufficiently broad enough appeal to support such expensive projects, mind you.)