Now that I've given Skyward Sword some breathing room after my second play through, I can honestly say I was pretty let down by it.
Interesting that the game was received so well overall for a couple of reasons. Firstly, the things people complained about in Twilight Princess like hand holding and linearity, were put on steroids for Skyward Sword. Secondly, it has sold the worst of any console Zelda title except for Majora's Mask.
That said, flaws and all I loved Twilight Princess, but there were just way too many backward steps taken in Skyward Sword for me to really love it. I think in a lot of ways it's like the Other M of the Zelda franchise.
I was really disappointed by SS. I enjoy almost all Zelda games (even Phantom Hourglass), but too many things missed the mark in SS for me. I thought the game was fine during the beginning, but it started losing steam after the first visit to the desert. One thing I didn't like that I never hear about is SPOILERZ: Zelda actually being a goddess in human form.
I vastly prefer Twilight Princess. Did a lot of people who don't like TP play the Wii version? I only played the GameCube version, so I have no complaints about lame motion controls.
I've only played the Wii version but I love it. The sword controls are maybe the only area where I feel that Skyward Sword actually outshines Twilight Princess, though it's a shame they had to overdo it by using motion controls for swimming and a couple other mundane things.
Funny you mention the beginning, I found that part an absolute chore to get through. Until you actually land on the surface, you spend way more time watching the game than playing it, with unskippable cutscenes and dialogue. And it's all so lighthearted and goofy, it really makes it extra hard to get through if you aren't a particular fan of the art style, which I wasn't (on a side note, no game released in 2011 should look this bad, it's inexcusable). It's an extra bit of chore on Hero Mode, since some of the characters acknowledge that it's your second play through, yet still lecture you and make you do all the tutorial stuff (at least you can skip the cut scenes this time around).
Back in 1986 it was simply "It's dangerous to go alone. Take this!". Bam. Adventure.
Now the games require two hours of intro before you actually do anything relevant. This was a problem in Twilight Princess as well, but it was not nearly as severe.