Its like Silent Hill 4, you either love or hate it, or both.
There are quite a few who say this is The Worst Zelda Game, I wouldn't go that far, but there are definitely some issues that badly needed to be addressed in the early-design stages of its development.
First of all, let's address the motion controls. In theory, this is a brilliant idea. You can run around slashing your sword for immersion. In practice, the Wiimote reaction delay cripples it. Don't get me started on the flying controls.
Fighting that clown Ghirahim multiple times. The Imprisoned rears its ugly head THREE TIMES? (and again if you want the Hylian Shield?) Was this really necessary? A boss battle where the boss runs away from you is not a boss battle. Its a timed mission.
Strangely, the most fun I had with the game was the Silent Realms! Yes! I kid you not! The worst, most horribly designed part of the game, was by-far the most entertaining. Link's spirit running from the servants of the gods was exhilarating, especially when the camera inevitably bugs out and you run head-long straight into a guardian after silly mandatory cut-scenes. *cue panicked screams*
Now for story: Sorry guys, its bad. Link's relationship with his Loftwing is poorly executed. Fi can go get lost quite frankly. I'd rather his partner be the red bird. People who complain about personally-subjective annoying companion characters such Navi and Elzo, need to spend time with Fi. She is *objectively* the most infuriating condescending assistant Link could ever ask for, constantly feeling the need to explain EVERYTHING. Why isn't there an option to TURN HER OFF!?!
This "prove your worth" nonsense NEEDS to stop. Link is a hero. He IS NOT the cosmic plaything of the gods! This game takes this ridiculousness to asinine levels. Link has to prove his worth for the Master Sword, then he proves his worth for the three Sacred Flames, and then proves his worth a few more times for the Song of the Hero.
Hylia is so unlikable, its easy to portray her negatively since she comes off as a Jerkass God. She puts Link through HELL, just to circumvent the Triforce's rules, and use him as a puppet to make her wish on the holy relic - the destruction of Demise.
Hey genius? Why not utilize that unlimited power and wish for Demise to be good?
Horrible story aside, you might actually have fun with this in places you'd never think to look. Its worth renting.