Some friends and I actually had a big discussion about this earlier this year. I'll list below what I believe are the greatest US home consoles of all time. However, this list is NOT the same as my 10 favorite of all time. In fact, after thinking about it for days, I was surprised to find that my #1 pick for greatest console is nowhere near my favorite. Considering ALL things - hardware and library, I think SNES is the greatest console ever. (Again, I love SNES but I'd take a Genesis first any day). You simply can't deny that the SNES nailed it - great hardware, comfy controller with shoulder buttons, great library of truly amazing games. For all you PS2 lovers (the choice of a few of my friends also), I would have rated it higher but I had too many optical drive problems over the years.
Here's my list: Top 10 US Home Consoles of All Time
10. PS2
9. TG-16
8. Dreamcast
7. Vectrex
6. PS3
5. N64
4. Atari 2600
3. NES
2. Genesis
1. SNES
Those that didn't quite make it: Colecovision, Intellivision, PS1 and GameCube (though the GC controller is my favorite controller of all time)