Over at the Thumb Gods, they’ve posted a huge list of consoles, dating back to 1972. They’ve got the works, including links to wikipedia for your knowledge edification. No handhelds, however. Perhaps that’s another post.
I count 46 consoles, of which I have owned 6 (I know, weak) and I mashed buttons on 20 of them.