Is Breath of the Wild really that good?

[patronmacabre]

I just want to know if it's worth getting the game for me -- someone who just can never get into Zelda games. As a huge fan of melee based combat action-adventure games (like the Souls series) and puzzle games, I feel like I should enjoy Zelda games. But in practice, I never do.

I forced myself to get through Ocarina of Time, and it took approximately six playthroughs for me to finally beat it because everyone was yelling at me to appreciate it. Retrospectively, the only part of Ocarina of Time I enjoyed was Spirit Temple (which was fantastic, though the boss was really dumb and unfun).

I could never really get into Majora's Mask or Twilight Princess, though I did enjoy Majora's Mask's aesthetic. I adored the visuals of Wind Waker and really loved the idea of sailing, but when it came to the game itself, I couldn't stay interested. And I never tried Skyward Sword.

The only Zelda game that I can say I genuinely really liked was Link to the Past -- even though I never beat it myself. I just got halfway through.

So, I guess what I'm trying to get at is this: is BotW worth it for someone who's not a Zelda fan? Keep in mind, I adore Souls and Portal and adventure/puzzle games, I like (but don't love) Skyrim, and I adored Fallout: New Vegas due to its phenomenal sense of humor and great writing. Interesting stories, good writing, and compelling visual design are an important piece of motivation for me in video games, because I often can't get by on "just gameplay" alone -- unless it's Civilization, Project DIVA, Pokémon, or any Blizzard game.

So, I have three big questions:

1. How compelling is the story?
2. How good are the bosses? Zelda usually has terrible bosses, but if they are exciting, I will be convinced. They don't have to be the level of quality of say, Martyr Logarius, Artorius, Sif, Abyss Watchers, or Gehrman, but I want them to be something I look forward to.
3. Is the weapon durability system actually fun?