Guise of the Wolf is not part of series many people love. It is shit, almost nobody expects it to be anything else than shit and it is unlikely that someone bought it with high expectation and felt disappointed how his favourite saga turned out (if only because it's not part of any).
The other games you mentioned, though, are exactly it. They are part of some series and people are expecting some degree of quality when they are buying it and thus are naturally disappointed even when it is nowhere near the level of quality of the most broken game that exists.

Same with movies. No one expects something like SyFy movies to be any good and even when they are awful and it hurts eyes to watch them, it is not disappointment, people expected them to be terrible. On the other hand, from movies with big budget, big hype, with reknown director and based on something well known and liked, people expect different level of quality and fell disappointed when it doesn't match their expectations.

Also you are always exaggerating with everyone hating something.
A lot of people are satisfied with ie Hobbit. I for one don't like Hobbit 2 too much but I would never say I hate it. I dislike it because the novel it is absed on is basically fairy tale and they turned the movie into yet another action flick revolving mostly around cool action sequences. Doesn't mean I wouldn'twatch it some time in the future again.

I don't hate Skyward Sword at all. In fact I think it's a pretty good Zelda game overall. Biggest flaws are a disappointing "overworld" which isn't very interesting to explore (the sky), a flaw it shares with Windwaker's sea, and that the motion controls sometimes get de-aligned, usually during intense battles. Also, it starts very slow like most modern Zelda games.

Other than that, I liked pretty much everything about it.

Still linear. The objective is to get from point A to point B movement wise.

What? you only return to the region 3 times. Not the dungeons themselves. The only time you return to a dungeon you have beaten is Skyview Temple and that was just going through it to find another hidden area. The Volcano and Desert has another dungeon entirely besides the first 2 you beaten.

Also perhaps its the Soundtrack that kept me playing the game entirely. And oh man you missed out on the second desert dungeon the Sandship it has the most creative puzzles I have ever seen in a zelda game, just look at this:

http://www.youtube.com/watch?v=tnKQ9NbDMh4&list=PL57E94FEF25A56A19#t=412

Basically you are sailing in a desert that used to be an ocean and with a time sphere you created a zone that makes you in the ocean of the past in a circle surrounded by current day desert sand.
Though empty the Sky does have a nice athmosphere thanks to the music accompying it:

http://www.youtube.com/watch?v=nRbROTdOgj0

Makes you want to fly in the Sky ;)

SS is a nice Zelda game but I really hated that annoying B* of Fi and the story could have been made by a 3 year old. The cheapest way of introducing a main villain that keeps reappearing. Kinda ruined Ganondorf for me. Gameplay-wise it is a good game. I also didnt like the linear dungeon-esque world. Something different, sure, but I prefer the previous open world type. Fi makes me hate the master sword now but I just black out SS's story in general because its so bad. Dungeons itself were nice but easy to figure out. The one with the time-rock thingy was nice though but they all were waaaaay to easy.
Like I said. It is not a bad game at all, it is really good. Its just that it was kinda average for a Zelda game, plus we waited an eternity for it to release so people expected more I guess

I'm not going to get too in depth, but actually my experience has been most everyone I know that like Zelda love SS. I really like it, but it hasn't really grabbed my attention like Wind Waker or A Link to the Past did. One of my friends hated it at first because he didn't like the way it looked but after he watched a Let's Play he really liked, actually he's still borrowing my Motion Plus for it. I know it has one of my more liked incarnations of Zelda's character and I thought it handled the opening stage better than previous Zeldas, but for many, many reasons (most not even the game's fault) I can't get into it into it.
Edit: For what it's worth I also liked Fi and am one of no one else practically who didn't get super annoyed at Navi.