I often think that nostalgia with older consoles sometimes blinds us of their flaws.
Despite being touted as a stronger console, it was only stronger than the NES (a console that was on it's way out - not a big achievement). With exception to processor speed, SNES outshined Genesis in most other specs.
It sold a disk-drive, an upgrade attachment and an improved controller to make up for faulty designs. Aside from Sonic, it did not have many memorable exclusives. So it mainly existed as a console-wars console with a darker tough-guy image.
Was a huge step back for Nintendo. It sold around half as much as it's predecessor SNES. It began Nintendo's weak third party relations. It lacked a diskdrive, when the PS1 over a year earlier had one. It had a string of strong exclusives, but most of them were Rare's accomplishments. The console didn't have a large game selection. Aside from 10-15 classics, there was really not much of a library.
To most people it was a fad, but most of its very few quality exclusives haven't aged well. It missed a lot of third-party, was weak on hardware, had horrible online and installed an paranoid friend-code system. Both Zelda games were massively hyped, and then largely forgotten by many gamers. Mario Kart and Smash Bros had weak online and are going to be replaced by their Wii U successors.