After almost finishing the game (I'm literally just up to Demise but the motion controls are annoying me so much I decided to take a break before finishing the game officially), I can say that Skyward Sword is not my favourite game.
It's quite boring, really, however I do appreciate the lore the game has given us. If anything, I played just for seeing the lore of Zelda's world but it's not a game I plan to replay anytime soon.
I do think the motion controls ruined it for me for the most part but it also just had a lot of wasted potential in the world as it was really empty when it didn't need to be.
More quests, the sky section being grander (and also a way to fly quicker because my god was it annoying how slow the loftwings are), more chance to really interact with the creatures of the world below and it would have been so much better.