It's an incredibly frustrating game, and it's infuriating because it does so much right.
The combat and the motion controls are actually really good in my opinion, despite the bad rap they get around here. Combat is engaging, Link controls very well, the items all make use of the motion controls and it's honestly great fun.
The story is easily the most captivating of all the 3D Zeldas. There's a lot of lore worldbuilding and many of the series' staple characters are shown to have an origins story. Zelda is a wonderful character in this, vibrant and full of personality, a vastly superior character to the BotW Zelda.
The locations in the game and the dungeons are both excellent, easily some of the best in the series. I actually really loved Skyloft and all the islands that would pop up as you progress, and the quests were charming as hell and great fun. The soundtrack is full of earworms and is fully orchestrated for the first time.
And yet...
Lots of minor things ultimately piled up and ruined the whole experience for me.
Fi is the worst thing in the game by far - she'll interrupt whatever you're doing to tell you that your remote is running low on batteries, relay entire essays to you about obvious things that don't need any explanation, and is about as interesting as dry paint. There is nothing redeeming about Fi.
The pacing is HORRENDOUS in this game. You're sent back to those 3 areas you just cleared midway through, and you have to fight the same bosses over and over again to progress and it's tiring and demotivating. This can be tolerable on your first playthrough, but I'm not even considering replaying this when I have to go through all that again. The tutorial at the beginning alone takes over 20 minutes to complete.
The areas outside the dungeons themselves, while pretty, are so linear and frustrating to navigate. Lanayru in particular is a chore to get through because of the timeshift stone mechanic - people tend to love it, but I think it only looks cool and the novelty wears off around the 5th time you are confronted with it. Don't even get me started on the Spirit Realm parts.
And ultimately, Link is beyond dull, and there's sadly no way to customize him beyond equipment upgrades.
So while this game does a lot of things right, and I personally love the artstyle and the presentation as a whole, all these baffling choices made by Nintendo make it suck for me and I find it really difficult to recommend this game to anyone. But hey, maybe I'm being too harsh here.