Yeah, you're not alone in wondering what all the hype over BoTW is. I'm currently playing through it again and noticing the same thing, the huge open world is technically impressive and fun to explore, but a lot of the content feels randomly placed in the world and it's pretty obvious which areas received extra attention and polish for their story quests. Combat for me at least also gets old really fast with the super annoying weapon breakage and poorly balanced combat damage and damage sponge enemies later in the game that rapidly eat up weapon durability.
I personally found the shrine puzzles to be one of the weakest aspects of the game, I liked finding the shrines themselves since they're fast travel points and give spirit orbs, but the puzzles themselves largely felt like a chore with only a handful of actually interesting shrines. Not to mention that most of the shrine puzzles look like something put together with a fairly basic level builder tool using a bunch of simple prefabs. In other words, the shrine puzzles feel really rushed. My favorite shrine puzzles were the shrine quests that revealed the shrine which just had a treasure chest inside, as the quest itself to find the shrine was the puzzle, and often was far more interesting than another throwaway one-off puzzle with an annoying gimmick. My least favorite shrines were the ones with motion controls. Nintendo needs to stop having parts of their games locked behind such a gimmicky, frustrating and unreliable control mechanism.
However I have largely enjoyed the town quests, even if the divine beasts themselves were largely disappointing. Neat concept of having a dungeon in a giant active machine that can be manipulated, but way too little content in them, especially the Rito and Goron ones.