Skyward Sword had a great story and characters, and it really served as a motivation to keep playing. It's still my favorite Zelda game, with BOTW being #2. The fact that there are other Nintendo games which I think have even better stories is just a testament to the fact that Nintendo and its development teams can make some really good stories when they want to.