Hmm it all would be deoending which Zelda game it was. But I can say the places of the games I have played so far.
Oot: Lake Hylia, Zoras Domain (I just love water paradises and the element water), Gerudo Valley (seriously that place would be cool, hopefully I won't get inprisoned though) and Dessert Colossus and Haunted Wasteland (I've allways found desserts beautiful and religion interesting. To visit the Spirit Temple, the goddess of sand would be very interesting).
MM: Great Bay (oh how I love oceans and beaches), Woodfall (I love tropical places plus that they're very interesting), Ikana Valley (I love mysterious and ancient places like these, hopefully I won't see any gibdos though).
WW: Windfall Island (this place really struck me as it has a special beachy town feeling in it).
TP: Lake Hylia and Zoras Domain (again, how I love water and such places), Ordon Village (I really liked the place, it was calm, peaceful and friendly village-like),Death Mountain, that mountain and also the mines were truly a enjoyable and cool scenery, what an adventure. I'd love to go there for sightseeing), Dessert Colossuss (again, love desserts. It would also be very interesting to see the Mirror chamber aswell), Sacred woods (I'm not so much into forests usually but this forest looked so nice and fairytale-like. I also love the history and the ancient ruins there, truly an interesting and nice place).
ST: I don't remember the name of that nice village in the ocean province but as I love the ocean and such, that is really a plce for me.