I didn't like Wind Waker--there was too, too, too, too much water and it takes forever to get from one place to the next; you can teleport, but that's after you find the guy. I gave up at the part where you had to find all 7, or 8, of the Triforce piece.
Twilight Princess is a bit long, but it was still good. People have said that it's better for the Gamecube then it is for the Wii

Ocarina Of Time, A Link To The Past, and Majoras Mask are my personal favorites for big councils. For Handhelds they are: Links Awakening DX, Oracle of Seasons/Ages, and believe it or not, Phantom Hourglass. [fyi: I haven't finished Twilight Princess yet, so I won't state my opinion until it's done which could be any day now, been too lazy to play it. Also I got Windwaker on the very day It came out, [I pre ordered it] and I enjoyed it, most people treat it like a stepchild but to me it's the same old Zelda with a twist, cell-shading. I played it to the very end, it's not on my personal favorites but I like it alot anyway. ]