Odyssey is a fantastic time. Skyward Sword vs Link's Awakening is a tricky comparison because you're comparing a 3D Zelda to a 2D one, and that generally makes for fairly different experiences.
It's probably one of the most hit-or-miss games in the series. A lot of people really hated it, others really liked it. Part of that is the motion controls, which just didn't work for a lot of people (I've seen the theory that some of the WMP's that were bundled with the game when it launched were defective, but I haven't seen that confirmed), but beyond that, people panned the lack of a proper overworld, the rather annoying unskippable tutorials (dunno if that's been fixed in the remake), the fact that regions get revisited instead of, and a few other bothersome quirks. On the other hand, though, it's got some of the more interesting dungeons, puzzles, and bosses in the series, the upgrade system for items is pretty nifty, and the story is one of the better ones in the series. I liked it, but your mileage may vary.
I played the hell out of the original Link's Awakening so maybe I'll get if if it ever goes on a 10% off sale or something. For Odyssey I have the cereal box still. Been waiting to get a Switch for that long.