I liked Oracle (I guess I'm the only one) I loved how you have to play both games to get everything.
2nd would be "Link's awakening" and 3rd is OoT.
don't get me wrong, OoT is great, I guess I love how simple, and yet complicated, the GB zeldas can be. it reminds me of the original.
the worst is Majora's mask. I've only played Windwaker like 20 min. and I didn't like it. Not the gameplay, but the way it looked. I liked Cellshaded games, but it just wasn't Zelda for me, I guess I have to fully played it before I say anything else.
The new Zelda looks great, good thing Nintendo (or Miyamoto) is going back to the older look.
BTW Fruit of the Mysterious Tree... is Oracles. I think that was its name in japan.