I've played Link's Awakening DX, Ocarina, Wind Waker, and am currently partway through Link To The Past. Wind Waker's my personal choice, and call me blasphemous, but I don't think LTTP is all that. It might just be that it's not really suited for playing on GBA. Been thinking about investing in a Game Boy Player, my curved spine would certainly thank me for it...
I would say windwaker was a let down because I wasn't expecting it to be the same as OoT to begin with. Wind Waker was still a birlliant game, just not at the same standards as the previous two in my opinion.
Im thinking of buying the Nes Collection version of the original zelda and playing fully through that and then LttP and playing through that before I go through OoT again. I've played those two before but never got round to completing them.
This new Zelda i'm completely hyped about to the same level as pre-OoT. I want it very much. Oh yes.