Well, I'm sold. This is pretty much exactly what I want from Nintendo's next system. No stupid gimmicks - just gaming. And I love that I can now just purchase one Nintendo console to cover home and portable. I'm hopeful that, since it is cartridge based, it'll be backwards compatible. As a handheld, I think think 900p on a tablet sized screen with traditional sticks and buttons is awesome. And as someone who isn't a graphics whore, it's perfectly acceptable to me as a home-console, especially since they'll have a pro controller available right out of the gate. One of my biggest worries was whether or not I'd be forced to use only the detachable controller(s) all the time. I always did like being able to play WiiU games in bed or whatever via the GamePad, but it was severely limited. It's nice to see I'll be able to continue that on the Switch to a much higher degree of quality. All that's left now is to see if it'll support GameCube controllers for Super Smash Bros Switch.
The system seems to be off to a decent start third-party game wise, but I personally don't care much about that other than the fact that it would be nice to see more than just hardcore Nintendo fans buy it. I've gotten to the point where I have no expectations from a Nintendo console on that front. If the third-party support continues, great. If not, fine.
Best thing from the reveal trailer to me was what appears to be a new, truly 3D Mario title.