Link to the Past. OoT and Link's Awakening are tied for 2nd place, but I also must admit I haven't played any console Zeldas past Majora's Mask and the last one I played period was Minish Cap on the GBA, so I'm totally out of date. LttP was my very first adventure game, very first game with ANY kind of story to it(minimalistic as it is) which eventually got me into RPGs so it will always hold a special place in my heart. 3rd place goes to OG NES Zelda.
That said I need to play the GC and Wii Zelda games. I do however prefer the 2d overhead view to 3d from a stylistic and gameplay standpoint but that's partially because I grew up with old 2d games and have a lot of fond memories of them from grade school.