It's a matter of opinion. Obviously if you've had some really bad experiences with motion controls in the past, you're going to be a bit biased against them. I've played several wii games and the only one with motion controls that I actually liked was Wii Sports. I swear, there's a spyro game for the wii that is unplayable because of its motion controls. My sensor just wasn't picking up the commands. There was an Avatar game that came with it, and I nearly had to stop that as well because the motion controls weren't responding and the thing was timed so I had to start all over if the motion controls suddenly decided not to respond.
I played Twilight Princess on the GameCube which I loved to death. I like when games let you have the option of using a controller. Like Mario Kart for the wii I can't play with the wii mote it just doesn't work, but with the GameCube controller, it's super easy.
Individual experiences may vary as far as the motion controls are concerned. For some people, they may work with no problems and for others it may seem impossible to get them to work right or at a non-laggy pace.
I refuse to play Skyward Sword, not on the grounds that Yahtzee dissed it but on the grounds that the trailer looked terrible to me. I HATE that cartoony style and they brought it back. Why can't we get the more realistic graphics like with Twilight Princess? Wha!
To me, just the very concept of having to swing link's sword around for him is completely ridiculous and appalling. How dare Nintendo make me have to act out an action that was easily input in the past with the freakin A button on the controller. And ya know what? When you hit the A Button it never miss-fired like motion controls tend to do when you accidentally move the controller out of range of the motion sensor. How dare them.
If I wanted to swing the wii mote around a whole bunch, I'd just play Wii Tennis. Don't put that shit in a Zelda game and then NOT give us the option of using a GameCube controller. Grrrrr
I'm sorry, but motion controls are always ass no matter what game you're playing and they always add nothing but frustration and sore muscles.