I'd like to add Max Payne. The games were so damn good and the storyline could've worked so good as a movie and then it comes and it's like... eh. It wasn't horrible, but it sure as hell wasn't what it could've been.
To this day, 'Alone In The Dark' had me so excited, mystery, horror, an eerie haunted island, native american superstition, grisly experiements and fear, oh the fear. Then, Boll was attached - then I actually saw it - I died. So much wasted potential for unrelated, derivative and poorly made cliche drivel.
Other than that, more recently, 'King Kong'. A victim of excess in regards to (sometimes shoddy looking) effects and tried too hard to be epic. Plus, lots of silliness.
I think I'm simply going to sum up and say every film in the past 10 years based off a video game. So far, everything has come up short or begged for viewing apocalypse. I don't think there has been a video game-based movie that I have enjoyed after the first viewing. No exceptions.
Wall-E. It received great reviews, but I literally spent the first hour waiting for something to happen. And even after that hour, it wasn't particularly special. I was tempted to just stop watching it, but I didn't have anything else to do, and I wanted to see if it ever redeemed itself.