The PS2 was the best console ever made. It had its own great library of games, and also full backwards compatibility with the PS1 (which had on its own perhaps the best library of any console ever). It was pretty much perfect.

SNES does certainly deserve an honorable mention.