catutie, OH WOAH WOAH WOAH WOAH
You did not just say that Majora's Mask is bad. And for the love of god take back Donkey Kong 64. Majora's Mask can be a little tedious, but it's on the same stage of tediousness as Wind Waker with the sailing. It's not a hard game (No Zelda is hard apart from the first two. Even then it's only hard for an 8 year old.), by any means, it's as you say, you're missing something. (It's voted game of the decade for a reason.)
And Donkey Kong 64 was just a mess, best kept swept under the rug.
Now, I don't want to start ripping into you for that because that will take days. But I do understand where your coming from, I do agree that the DS version is terrible, and yes the sunken ship is nutorious for being the worst level in a mario game. But I usually judge a game based on the time of when it came out and what the standards are for that time.
As you say, it was ground breaking for it's time, and it's still on a much higher plane than some of the titles that came out on the gamecube after it. Going into the same scenery over and over again feels like backtracking, but games like Mario 64, Mario Galaxy and Metroid at a reach, give great level designs and unique features based on the stars you already have. Not to mention good eye candy complete with brand new features the game offers. However that just might be me as I play very linear and go for the objective if I am going back there afterwards.
You don't need all the stars from each course to continue and if you do it this way, you can find new challenges and surprises after you have beaten some of the later levels and come back to the earlier stages in the future, giving a varied sense of gameplay and adventure.
Metroids backtracking is completely optional (not trying to imply that the mario titles are mandatory) and it requires exploration, so I wouldn't count it in the same topic, but it still makes backtracking fun, or at least bearable. Galaxy for example, Luigi plays differently, jumps higher, runs faster and essentially makes the game a lot easier. I have completed it with Luigi and it only took me half the time as I did with Mario.
/Obvious massive fanboyism