None of the new console designs really interests me. I do like how tiny the Nintendo systems have been of late. They just really need bigger controllers; the GameCube one nearly crippled me to play Metroid Prime. Maybe the Revolution will correct that, but I doubt it.
The Xbox looks again too much like a PC (now a melted tower), and the Playstation is too much like my modem.
Being able to download all previous Nintendo games for the Revolution is simply one of the best uses of online capability put into a machine, imo. It caters far more to people, like myself, who have no interest in online competition, but still want to get use out of an online connection. They really hit on a great idea with that. Not everyone likes or feels comfortable using emulation on a PC, if they know how to do it at all. Being able to play Nintendo games from any era on a Nintendo console is really a stroke of innovation on their part. It almost makes up for the DS....almost.
Like before, Nintendo has managed to make a system that actually interests me enough to buy it along with one of the bigger two. I won't buy it at release, but I'm pretty sure, like the Gamecube, I'll get one eventually. I suspect a lot of Nintendo's buyers will fall into that same category. While it may not be their glory days, at least they're adding variety in a consolewar which is boiling down to "the same, but better".