From current gen, I'd say I've had the most fun with the Wii. Not that there haven't been any good games for the other two consoles, some particular favorites being Fallout 3, Red Dead Redemption, and NieR, but I found that the motion controls, at least utilized correctly, add a whole new layer of depth to already fun experiences in Zelda or No More Heroes or the Metroid Prime games. I've played more for the 360, but most have been mediocre, whereas the few I've touched on the Wii have been significantly better experiences as a whole.
As far as favorite console ever, I'm really not sure what I'd choose. I've had plenty of fun with all of Nintendo's consoles and handhelds, and each have their own pros and cons. As for others, while I've had fun with stuff like Sonic or Spyro or Metal Gear Solid, I can't say I've had much more than those to go off of so I really could not judge them properly.
_________________
About suffering they were never wrong,
The Old Masters: how well they understood
Its human position; how it takes place
While someone else is eating or opening a window or
just walking dully along...