Quite honestly I don't think Zelda has a bad title, each has their strengths and weaknesses sure, but I think each game accomplished what Nintendo wanted to accomplish. I really think games get an unfair judgement passed on them in comparison to their predecessors, take Other M for example, It's a brilliantly done game, it was MEANT to be a cinematic, and yet people are whining about the fact that its too cinematic, or that Samus wasn't portrayed exactly as they imagined. Samus had her entire colony along with her whole family DESTROYED at the very tender age of 3, that leaves some pretty lasting damage, and I wasn't surprised or offended by her reaction to Ridley, and yet people are saying she was being "too weak" or "too submissive" to Adam, she was being respectful, she could have chosen to break orders at any time, and Adam was busy with other things as well so him not authorizing something can be taken to mean many things.
Lesson: Don't judge games by their predecessors, judge them by their individual merits. I found Skyward Sword to be VERY enjoyable, while I found Majora's mask to be a bit dry. That's my personal opinion and no it's not based on my previous experiences.