You cannot translate a medium built entirely on interactivity into a non-interactive medium and expect it to not come out awkward. I would much rather control my favourite video game characters rather than just watch them do all the action. This is why I hate so-called "movie games" like Metal Gear Solid, Heavy Rain and a vast number of Japanese RPGs.
The Prince of Persia movie wasn't too bad, although I've never played the game.
I WOULD want to make a Zelda movie, but I realised it'd have to be either about Twilight Princess or being CGI. Skyward Sword, in particular, has so much special effects it'd be nearly impossible to make a real movie with it.
A CGI movie about video game characters in general.
Oh wait, WIR.
Okay maybe some sort of CGI Mario movie that takes elements from all of the spin offs as well as the Main Series. Maybe Bowser cheats in a MKGP race which turns into ruling the Mushroom Kingdom, so that means that Bowser finally succeeds in taking over the kingdom.