I'd been playing Zelda since the first one since I was about 3 or 4. Even got to dabble with the CDI versions though they didn't keep me playing very long. The one I've put the most amount of hours into though would definitely be Majora's Mask. I love it more than I do Ocarina of Time, though Ocarina is definitely my second favorite console one, followed by A Link to the Past, then Wind Waker. I haven't got to play much of Skyward Sword, though I'm slowly getting to it.
Handheld wise I've played all but Spirit Tracks, and Oracle of Ages would have to be my favorite one on there.