I've not read through the whole topic but I always did enjoy Zelda games.
The first Zelda game I played/finished was A Link to the Past on the SNES. It was, now I think back, likely the game that got me into gaming. I was young at the time, parts of the game had me stuck for months, it took me more than a year to finish on my first save. I still wish Zelda games had as many dungeons as this one did.
Ocarina of Time blew my mind again and again but still now I consider it I prefer Majora's Mask. Call me a heretic if you like but it's different from what I expected and remains a pleasantly surprising, yet odd, game. fake edit: looks like we're all heretics.
I got a lot of enjoyment out of the GameBoy / Colour / GBA Zelda games. I need to go back and play them again I can't remember them in much detail, just that I enjoyed them. I just wish the DS Zelda games we're half as good.
Unlike many I know I really enjoyed Wind Waker. I found the art style charming and more than fitting. Brilliant textures, particles, the shape of things, everything. The only downside was the lack of dungeons, if it had been as long as Link to the Past it would easily be a contender for my favourite Zelda game. More varied weather and climate would have been nice, bigger storms at sea for example. I preferred WW to Twilight Princess.
I've always said I wanted a more open-ended game set in the Zelda universe. Which is odd with MM being one of my favourite Zelda games. Then again MM is open ended to an extent, many paths and quests in a limited time. An open-ended WW style game with some larger landmasses could be interesting.