NES, SNES, Genesis, Dreamcast, R-Zone, Gameboy, Gameboy Color, Gameboy Pocket, GBA, GBA SP, Virtual Boy, Gamegear, N64, PlayStation, PlayStation 2, PlayStation 3 (used to), PlayStation 4, GCN, Wii, Wii U, Jaguar (used to), 3DO, NeoGeo, Atari 2600, Xbox, Xbox 360 (used to), 3DS XL, PSP (used to), PS Vita (used to), and that's all I can think of off the top of my head. I can edit later when I get home and double check.
By far and hands down, SNES is my favorite console. Just had the absolute best games, best visual style, vast amount of titles, the amount of quality titles, the insane amount of fun almost every game provides, and the longevity that both the games themselves and their respective visual styles have. By that I mean how they have held up through the ages.
I revisit a lot of my SNES games frequently. They still provide me the same level of entertainment, if not more, that they did when I first acquired them. Almost all of them bring me more entertainment value than the majority of games released in this age of gaming.
My second would probably be the PlayStation 2. I would say PlayStation here, but the PS2 is completely compatible with PS games. So, I can enjoy both era with it. The reasons for it are pretty much the same as those of the SNES.
However, games just aren't made the same any more. Now it is a focus on money and online multiplayer as opposed to a genuinely fun, engrossing, and solid experience. There are definitely exceptions to that rule. But, for the most part, it stands true. They just don't make 'em like they used to.