I can only speak for myself, but I absolutely loved Skyward Sword. I think that the presentation is behind the curve in some respects, but the gameplay is far above the curve in many respects. The level design in Skyward Sword is simply head and shoulders above anything else coming out on consoles these days. Play through some of Skyrim's dungeons, some of Arkham City's environments, and then play some through Skyward's dungeons. Zelda's level design puts most other games to shame (of course, I'm not saying that those games don't have other advantages). I thought the motion controls were incredible, and the score was superb.
Strange as it may seem, I also really enjoyed the story. It may not be the deepest experience out there, but it's simplicity and sincerity is a welcome change compared to other games out there.
It seems to me that people just weren't prepared to judge this game based on it's own merits. Some people wanted a super hardcore game that didn't cater at all to newcomers like Dark Souls. Others wanted a game with top notch production values and the cinematic quality of Uncharted. Others wanted a crazy in depth roleplaying experience like Skyrim, and many people wanted the vast overworlds of Wind Waker and Twilight Princess. I don't think all that many people came into Skyward Sword with a completely open mind, which is contributing to their disappointment.