I remember the original NES Legend of Zelda the most fondly, but I never had a N64 or SNES myself. I played the latter a fair bit with roommates though. I do have the Wind Waker, which was great until the ocean scenes where you're supposed to collect all the triforce shards. I've never finished it because of that, although I recently picked up a strategy guide for the game. Maybe once I finish Twilight Princess I'll give finishing it another go.
I do intend to get to the rest of the Zelda games over time, starting with the N64 Zelda ports for the Gamecube - as soon as I finish playing Link to the Past on the virtual console. I'm pretty sure I already have more games than I'll ever have time to play fully...