This is how I feel about many critical darlings. Pretty much any FPS, no matter how critically lauded, I find utterly dull. People love Bethesda games, but they are never more than 'ok, I guess' for me. Playing Skyrim sounds like pulling teeth for me.
Zelda is the absolute best at what it does. There are so many things Nintendo just nails that other games like it fail at. The atmosphere, art design, world building, music are all top notch. There isn't another game in the genre that can reach the musical heights of the Gerudo Valley or Epona's song. I could list a dozen songs, the series has really been one of the best. In fact I'd rank it, Metroid, and Final Fantasy as the top 3, and there is a significant gap after that.
And mechanics and puzzle design has been historically very tight. BotW excluded (as I haven't played it yet), the series has used the mechanics and upgrades to clever effects throughout. Combining powers and tools in interesting ways, and requiring most tools to serve multiple purposes. They never get hard, like Talos Principle type games, but that's also not the point.
It is clear that Nintendo spends a lot of time and effort considering the user experience, how they'll play the game. How the design space is structured. The world designs are crafted to help guide the player experience. To set the atmosphere. To introduce new ways of playing, while staying true to the roots of the series and why people love it.
And it may not just be for you. If the music, art, animations, world design and gameplay of Kakiro village doesn't draw you in, if you get hung up on how the combat doesn't do XYZ, or something something loot? Then... it's not your thing I guess.
That said I appreciate and respect how you approach it. Unlike some others who seem to have a hate boner for all things Nintendo...