My favorite Zelda title and the only proper title that I've played to complete ion is Skyward Sword. Fantastic game, if a bit short. Story was well written and organic, combat was stimulating, and much much more.
My least favorite Zelda title, and this is only CURRENTLY so as I haven't played...