Yeah, I personally thought the ending was a bit underwhelming, and especially from a story-standpoint the game is quite weak. But the locations/environments/world are the game's strong point, and it's definitely a very strong game. Personally, with the exception of Majora's Mask, I've found the stories in Zelda games to be pretty weak. The reason I've always played them is for adventure and location. So if the setting is interesting, I'm likely to have a good time.
Weapon durability is the worst thing in this game and really brings it down. The fact that I got rewarded with a cool weapon I was too scared to use shows that there is a huge problem. It only serves to make the game less fun and doesn't really add any interesting strategy or challenge.