It had great hardware at it's time, and some of the great 2D still impresses today.
The thing which made the console great though, was the games. The SNES had a great selection of games of most genres.
Some of the best SNES games are: Super Mario World, Super Mario World 2: Yoshi's Island, Donkey Kong Country series, Megaman series, Super Metroid, Super Mario Kart, F-Zero, Chrono Trigger, Final Fantasy series, Secret of Mana, Seiken Densetsu 3, Lufia series, Earthbound, Illusion of Time, Terranigma, Starwing, Super Bomberman series, Street Fighter 2, Final Fight series and more...
Nintendo also was planning on a CD based SNES with collaboration with Sony but this partnership failed and so the "Playstation" was produced solely by Sony, and Nintendo forever lost the ability to have CD-ROM support in their consoles (They also messed up with Phillips).
Sensible Person: Kicks The Shit Out Of Graphic Whore And Breaks His Consoles And Says "Respect The Classics And Play The Greatest Console Ever Now!
Graphic Whore: (After 2 Hours Of Crying) Plays And Realizes The Sensible Person Is Right