We had the Wii - managed to score one the weekend it came out. But after about 18 months it became apparent this was going to have some real dumbed-down titles. A few stick out in my mind, most notably the Endless Ocean and Endless Ocean 2 games. I miss those enough I've been thinking of picking up a Wii after the Wii U comes out to replay them, when the price drops.
As for the Atari 2600 I had as a kid - I recall that having a greater variety of games that were almost more challenging. I don't miss it enough to buy the controller/ROM combination, but I distinctly remember titles we traded with friends and played for years. Maybe some of that is nostalgia for long summers and the lack of overall console variety then, but I was distinctly unimpressed with the Wii; with the notable exception the two titles I mentioned above.
When our Wii gave up the ghost I relented and bought an XBox for my son and that's been a great console - a good variety of games and ab online game store worth dropping some dough on. There will have to be something extraordinary for my generally Nintendo-friendly family to even consider by a Wii U. They lost us with the terribly poor game selection on the Wii and DS systems.