I'm happy to see a lot of Zelda fans on here.
Here's my ranking of all Zelda games (excluding Triforce Heroes, which I have yet to play).
1 - Ocarina Of Time - I grew up playing this game, so lots of nostalgia. Brilliant dungeons and amazing atmosphere
2 - Skyward Sword - Despite the motion-plus controls, this was an amazing experience
3 - The Windwaker - I love the setting and the nautical feel so much
4 - Twilight Princess - An all-round, epic and entertaining game
5 - A Link Between Worlds - By far the best 2D Zelda. So much fun and straight into the adventure
6 - Majora's Mask - I love this and it sticks in my mind a lot. A bit frustrating at times though. But very deep and memorable
7 - The Minish Cap - A little easy, but otherwise tons of fun
8 - Four Swords Adventures - This is underrated. I just found it a lot of fun
9 - Phantom Hourglass - Not as bad as people make out IMO, and the nautical setting helps it a lot
10 - Link's Awakening - Good all-rounder with some nice touches, love the mario enemy references
11 - A Link To The Past - ALBW made me appreciate this game more. It's a great game, but I just prefer some of the others
12 - Oracle Of Ages - I enjoyed this, and thought it had a lot more story to it than Seasons
13 - Oracle Of Seasons - Not too bad. But at times I found it frustratingly difficult
14 - Spirit Tracks - Some good things going for it, but the train stuff did my head in
15 - The Legend Of Zelda - I know it was the first. And it's an ok game. But the others are better IMO
16 - Four Swords - Too short, doesn't feel canon, kinda lazy, but not without it's fun at times
17 - The Adventure Of Link - Really don't like this one. Way to difficult and just not enjoyable for me
1 - Lald, 2 - Ltk, 3 - Avtak, 4 - Op, 5 - Dn, 6 - Fyeo, 7 - Tswlm, 8 - Daf, 9 - Sf, 10 - Ohmss, 11 - Yolt, 12 - Ge, 13 - Tld, 14 - Mr, 15 - Gf, 16 - Tb, 17 - Tmwtgg, 18 - Sp, 19 - Tnd, 20 - Dad, 21 - Twine, 22 - Frwl, 23 - Cr, 24 - Qos
1 - Moore, 2 - Dalton, 3 - Craig, 4 - Connery, 5 - Brosnan, 6 - Lazenby