It's damned stressful, and unfortunately, my Wii isn't helping much.
You see, it's just so damn fun to play.
Back when I was a kid, I could play games like Kings Quest 4 for hours at a time. A Link to the Past, Super Metroid, Wolfenstein, Doom, Heretic, Hexen, TIE Fighter, Dark Forces, Dungeons of Kroz, Warcraft, Warcraft 2, Starcraft, Zork and it's many sequels, etc. They all took up countless hours of my life.
Then, slowly, over time, I just began to lose interest in video games. I think Half Life was the last game I played completely through without getting bored and resorting to FAQs or trainers just to finish the storyline.
Civ 4? Boring after an hour or so. Used cheats to create a massive army of tanks to conquer the whole world.
Half Life 2? Played an hour of it, got bored, never bothered to go back yet.
Medieval 2: Total War? Played 2 hours, got bored, used cheats to get unlimited money, conquered 50% of Europe and got even more bored, and quit.
GTA3: I think I lasted a week before I gave into using cheats, and then just rocketed the police in one gigantic orgy of destruction.
I don't know what happened, but games have gotten so insanely large and complex that it's just not fun playing them anymore.
I bought a Wii because everyone at work highly recommended it. I work with people who don't really play games, so if they were recommending it, that really said something to me. So I grabbed it and Zelda, and have been playing it on-and-off for the past few weeks.
So far I've only had to look up one thing in a FAQ (where to find the 4th monkey in the first dungeon), and I've been able to do everything else without needing any help whatsoever.
In fact the game is so absorbing that it's becoming a problem. See last night I got home from work around 9pm, and I was exhausted, so I just popped Zelda in and started playing. 3 hours later, I realised it was midnight and I had to get to work in a few hours, and I really needed to go to sleep. Oops.
I think a large part of it is the controller design. Previously, you had to hold your hands in front of you for long periods of time, and this had a tendency to make your hands cramp up after a while. But with the Wii, you don't get that. You have the wiimote in your right hand, and you can hold the nunchuck over in your left, and it's far more comfortable than a regular game controller. I think without the "your hand is cramping, maybe you should stop playing" impulse being sent, it greatly increases the amount of immersion you have in the world.
Anyway, I highly recommend Zelda. I haven't been this into a game in 10 years.
As for the people who say it looks bad: I'd like to have some of the crack you're on, please. It looks absolutely gorgeous.