I'm a huge Zelda fan, and the franchise has a very special place in my heart, but i don;t like BotW either. And that's ok. Just because almost everyone got their knickers in a bunch about this game doesn't mean it has to appeal to everyone. Personally, i think it's extremely overrated and i think a lot of the praise comes from the sheer surprise that Nintendo, famously conservative at the best of times, actually released a sequel in a long running series that fundamentally changed things up. Did these things change for the better? Well, that's down to personal preference, but in my mind it did not. Sadly for people like me and the OP BotW was such a success that this is what the blueprint will be for Zelda for probably the next 20 odd games until they decide to mix it up again, which does make me sad as it feels like a beloved franchise of mine is suddenly on ice.
The things i expect from a good Zelda game seem to be missing in BotW and i suspect this may also be what the OP takes issue with. Dungeons, obviously, is a big one. I can appreciate what they tried to do but i did not enjoy my experience in any of the dungeons in BotW and that's one of the main draws of a Zelda game for me. Items, as well, are extremely lacking. You get all your tools in the first 30 mins and it's a miserly selection. That limit in available tools means less variety in puzzles and combat, the the fact that they are so frontloaded robs the game of the kind of progression that a gradually increasing toolkit used to offer. Speaking of which, the progression is all over the place, mostly because the game is designed in such a way that the game can be ended whenever you choose..
Zelda games aren't known for their complex stories/plots but pretty much all the Zelda games that came before trump BotW in this regard. The difficulty curve is bizarre as well, i seemingly spent the first half of the game being one shot by random enemies where i made the mistake of wandering into the wrong area. Then at some point after beating one or two dungeons and getting a few upgrades i went from more fragile than a wet paper towel to basically unkillable which, again, weird. Doesnt help that food unbalances the shit out of gameplay. Even if there is a difficult bit you can brute force your way through it by grinding ingredients for food and having a never ending supply of health and stat boosting options that can be used without penalty at any time.
Enough has been said about the weapon breaking, combined with the tediousness of the UI making combats a chore of stop/start nonsense rather than the free flowing idea they were probably going for. Weapon fragility makes exploring the world pointless. There are no more heart pieces in the wild, the only benefit to exploring is to find Korok seeds and they are so plentiful you dont even need to do this, you can make do with what you stumble upon. The developers built this huge and admittedly technically impressive world to traverse and get lost in but make it a chore to navigate (yay for rain when trying to climb, let me put the controller down and wait 5 mins for it to stop so i can carry on playing) and gave zero reason to bother. Why explore every nook and cranny when the only reward for doing so is materials for things that are plentiful anyway and weapon that will break 30 seconds into a fight?
Anyway i could go on but the point is that no one should feel like they have to play a game that is flawed in many ways because a lot of people looks past those flaws and find GotY material. I had a similar experience with Bloodborne. I played and loved (and fully completed as in got all achievements) all 3 Dark Souls games and came to Bloodborne expecting to be blown away as it's so often be referred to as the best Soulsborne game but came away after a few hours of playing the game entirely unimpressed and with zero desire to every play it again. And that's fine, God knows there are so many superb games out there vying for my limited gaming time, I'm not gonna waste mine on a game I don't like.