For me personally it's 64 > Galaxy > Odyssey > 3D World >= Galaxy 2 >>>>>>>>> 3D Land (Haven't played Sunshine).
Odyssey was great but it still was missing something for me. I guess I still prefer having the stars/moons/whatever tied to missions like in 64/Galaxy 1&2. I also really missed a hub world, it's such a basic thing but I'd still have liked one.
Oh, and even though I absolutely hated Zelda now having voice acting, I actually enjoyed the songs in Odyssey a lot, so no complaints from me there. That ending had a lot of charm.








