My opinion?
TLDR: Not a big fan. Only play it if your a completionist for the zelda games.
Full length: Ehh, it's not great. The hardest part is the opening few chapters. Not because it's difficult, but because it's tedious and often boring. So many tutorial, fetch quest, and triathlons, it takes so long to get to anything interesting, and even then, the first temple's boss is a bit of a let down. There is so much platforming for a zelda game, and It's bogged down even more by adding a stamina gauge. A STAMINA GAUGE! I mean, I like Dark Souls, Monster Hunter, even Shadow of the Colossus, but who thought a Stamina Gauge was a good fit for Zelda? It's not implemented very well, and again only serves to slowdown gameplay.
The story and art style are pretty good. Story is better than Ocarina, and the GBA games, but still loses to Majora's Mask, Twilight Princess, WindWaker, and even A Link Between Worlds. Art is second only to Wind Waker. So amazingly pretty. Fi sucks. She's Navi, but somehow even more annoying. She has a few useful tips here and there, but she is shockingly worse than the beeping sound at low health in a Link to the Past, and the original Zelda. It actually takes you out of the game sometimes, and she will actually break the immersion caused by the pretty art, to tell you you need to change your batteries, or that you health is low. And character wise, she still doesn't even hold a candle to either Midna and Tatl.
The motion controls are pretty give and take. There are a few cool things, and a few bad things, overall I dislike them, but they're not as bad as they could be. Fairly serviceable, but I definitely don't want them in Zelda wii U. And I guess my last big complaint is that They reuse the same boss too many times. It was kinda cool the first time, but they probably should have saved it until way later.