I only played it on Gamecube so I don't know how well the motion controls hold up. The GC version was fantastic, though. Graphics were touted as among the GC's best at the time but look like poop, now. However, once you get into the game, how it looks won't matter. That's how Zelda games are.
the GameCube version is awesomeeeeeeeeeeeeeeeeeeeeeeee