It's gonna be like every other Nintendo console since the N64- Nintendo titles like Mario and Zelda still sell tons of units, you get a couple of good third party Japanese-developed games, and apart from those it's gonna be a dust magnet most of the time.
But this time I see Nintendo either re-releasing an improved version of the console (with more HDD space, for example) and/or an improved controller with a better touch screen, resolution, and battery life.
And the N-thing hype cycle will begin anew.
Despite all that, you just know this system is going to dominate in Japan with its Monster Hunter 3DS port-up and Dragon Quest X Wii port-up lololololol, etc. etc.
This is the first console since the Jaguar and 3D0 that I don't see myself owning. Even with at least one game I'm really interested in on the horizon in Bayonetta 2.