Zelda's pretty front-loaded with story. It takes a while, but eventually you're are doing more playing than watching. It's not the most amazing RPG ever, but once you start getting to the dungeons, there's some good entertaining problem-solving.
Meanwhile, I'm gonna be an uncle.
