Wind Waker isn't really lacking in dungeons. There's 6 regular dungeons including the Forsaken Fortress, which is only two less than Ocarina of Time. I do feel that Ocarina has the better dungeons, but all in all dungeons are only one aspect of a Zelda game, and Wind Waker doesn't falter in that regard. I mean, look at Majora's Mask... it only has 4 main dungeons but it's still a great Zelda games regardless.
As far as console vs handheld Zelda goes, console is definitely superior. You got OG LoZ, LTTP, OoT, MM, WW, and the "epic" TP, as well as... SS. That's not to say the handheld games should be ignored, though. Minish Cap is imo the best handheld Zelda, with the Oracle games coming in pretty close. I'm having a tough time appreciating Link's Awakening, and while I'm sure it will grow on me much like the Oracle games, it probaly won't be as good as those to me. The DS Zeldas aren't bad games in and of themselves, in fact I think Spirit Tracks in particular has a great story and character development, but the touch controls take a bit of getting used too. Skyward Sword is also a great game at its core but it's muddled with so many little flaws that add up, in addition to a control scheme that, again, takes a bit of getting used too.
What I love about Ocarina of Time is its pacing. You start the file, you get a proper-length intro cinematic, then Link wakes up, heads outside greeted by his best friend Saria... and by that point you already know you're starting a great video game. Afterwards is the, again, proper-length tutorial process of getting your sword and shield(Tip: Get the 5 rupees behind the shop counter!) which takes no longer than 10-15 minutes, and finally you visit the Deku Tree for your first proper dungeon all within the span of an hour. Then you have to leave the forest and, well... that scene at the bridge man... the feels! Ganondorf has more character depth than Ganon, and while it's somewhat touched upon in Ocarina, you don't truly start to feel for the character until his reappearance in WW and, to a much lesser extent, TP. BTW, TP and WW are literally on opposite ends of the "Zelda Timeline", so that means the Ganondorf you encounter in both games is the same OoT Ganondorf, but in alternate timelines. That is pretty damn cool I must say. While OoT is more linear than MM and WW, you do get more freedom once you become an Adult, in that you can do the temples in any order you wish, despite there being a clear order. Personally I'd try to get the Longshot ASAP, so I tend to do the Water Temple before the Fire Temple, but I ALWAYS do Forest Temple first to get the Bow and be able to go back to Child form to complete Bottom of the Well. That's just me though.
What I love about Majora's Mask is, again, its atmosphere and nonlinear gameplay; It's probaly the most replayable console Zelda imo; That said, I always seem to have certain objectives in mind to clear, and I tend to try to stick to a schedule for 100% runs... speaking of which, I'm one of those people who can only seem to do 100% runs of most video games so I've never done a "minimalistic" run of Majora's, I ALWAYS get all the Heart Pieces and Masks, and it's definitely a lengthy endeavor, while if one were to simply focus on completing the 4 main dungeons(Though I highly recommend getting some heart pieces otherwise the Great Bay Temple boss will literally eat you alive), it's probaly one of the shortest console Zeldas... also Tingle.
Wind Waker, though, is truly a masterpiece, and it's not just the graphics, but they certainly don't hurt. In fact, if I had to make a direct comparison, Wind Waker's graphical style reminds me so much of a Miyazaki film(Albeit more stylized), and it's really amazing how even 10 years later the graphics don't seem to have aged a day. The gameplay has been refined from Ocarina, and Link is able to pull off more interesting moves, not the least of which the Parry Attack as well as the ability to pick up other enemy's weapons to use against them. The items you get in WW also add to the gameplay a bit more than in Ocarina, like the Grappling Hook not only serving as a "Ghetto Hookshot", but also a tool to steal "spoils" from enemies, which can be accumilated and used for various side quest, and then there's the Deku Leaf which has a dual purpose of creating gusts of wind AND as a parasail... riding the Deku Leaf to the Forbidden Woods is definitely a highlight. Of course, after the Grappling Hook and Deku Leaf you're treated to returning items and a couple updated ones such as the Skull Hammer(Which basically is Megaton Hammer 2.0), the classic Bow & Arrow, Bombs, and even the real Hookshot are all present and accounted for... oh and the Iron Boots are their own menu item YESSSSS. Enough about the items, talking about the characters now... some of the best personalities in any Zelda game I must say. You have Tetra the female pirate leader of a band of exclusively male pirates(Where have I seen this before...) who crosses paths with a newly 12-year old boy named Link, whose sister is kidnapped by an overgrown bird with a mask. Since Link saved Tetra from a horde of Bokoblins, he feels like she owes him a trip to the Forsaken Fortress to rescue his sister of course, so they set sail. Tetra's brilliant idea to get Link into the fortress... catapulting him right into the middle of the fortress... lol Oh but it's cool cause Tetra gave Link a stone so they could stay in touch... oh but wait, we later learn that *GASP*, Tetra is really Princess Zelda?! Ganondorf from OoT is back and stronger than ever?! Suddenly everything gets cray cray, as the newly revealed Zelda must stay behind in the now sunken Hyrule Castle, while Link heads back to the surface to reclaim the Triforce of Courage(Which has been scattered into eight pieces... more on that later). Along the way he's assisted by Medli and Makar, again more cool characters with decent personalities and development that are even playable(!) in specific dungeons. However, anyone whose played Wind Waker knows the main draw of the game: The big wiiiiide ocean that's ripe for your exploration, well at least only somewhat until you've beaten the second dungeon that is. Once you've cleared that second dungeon though, you're in for quite the task of exploring the big ocean, with every tile on that map housing an island; Though admittingly some are more interesting than others, and there's definitely a few filler islands, but all in all they don't detract from the exploration at all. There IS a quest near the end of the game where you're forced to find 8 shards of the triforce, where you have to find the associated chart before you can find the piece, and before that you need to get the chart translated by Tingle for a large sum... but honestly guys I don't consider the Triforce Quest a flaw of the game. It's not terribly enjoyable, but at the same time, Wind Waker rewards thorough explanation. What I mean is, a'lot of the Triforce Charts can be gotten before you get to the point in the game where you're forced to complete the quest. As a matter of fact, you can find 6 out of the 8 pieces before completing the Earth Temple, all that's needed for the other two is the Hookshot from the Wind Temple. While first time players may not get it right away, I find that should you explore every tile of the ocean before and after Tower of the Gods, you'll most likely stumble on at least a couple charts, and probaly surfaced a couple pieces from those charts as well(As the Grappling Hook functions as a treasure grabber... neat, huh?). Even if you wait til after the Wind Temple to do the quest, if you haven't fully explored the ocean then that is a prime opportunity to do so before the intense final battle... which I really don't want to spoil, even though I've already spoiled quite a bit at this point. All I will say is that moment is one of the most iconic video game moments imho that I've ever witnessed... and that is that. Wind Waker is a great game, and my favorite Zelda, nuff said.
Funny story though, there was a time where I was debating over whether I liked Majora's Mask more than Wind Waker. What pushed me over the edge? Two words: Ikana Canyon.
Okay, now, while I thoroughly enjoy most of Majora's Mask, I always always ALWAYS dread the Ikana Canyon section, which includes the Music Box House as well as the well with the gibdo item trading. After that though... it's back to awesome with the skeleton boss, Stone Tower Temple, and such. Point is, Wind Waker wins in my opinion because there is never a section in that game that I dread; I truly love every fiber of it, whereas I also love 99% of Majora's, but that 1% really does hinder things a bit... doesn't help that the gibdo man kept haunting my dreams for nearly a decade, and Majora's Wrath adds salt to that wound. Yes, Majora's Mask is a scary game, and I respect it for that... but still. STILL.
Also, every Final Fantasy game past X isn't worth touching imho. Yes I've played 12 and 13, and no I didn't like them at all. While FFX's story is debatable in quality, its gameplay is its saving grace... and then they made Final Fantasy X-2 and well... yeah. Things went downhill from there in terms of Final Fantasy.