Super Mario World is widely considered one of the best 2D platformers of all time
Chrono Trigger and Final Fantasy III still stack up as some of the finest examples of RPG Storytelling to date
Goof Troop is a hidden gem, a surprisingly good puzzle game.
Super Metroid and Super Castlevania IV are of course classics
As is The Legend of Zelda: A Link to the Past
Enix made some pretty unique games in this era:
E.V.O. Search for Eden has you guiding the evolution of your character from the beginnings of life on earth to the evolution of humanity
ActRaiser was a weird hybrid of action platformer and city builder
Ogre Battle: March of the Black Queen was a great strategy-RPG where you build armies out of a variety of monsters and heroes
Robotrek is an RPG with some interesting game mechanics around building robots to fight for you
EarthBound is of course a classic for it's goofy humour
Uniracers is an unusual unicycle racing game that's quite entertaining
Star Trek: Starfleet Academy might not hold up to modern standards, but it's certainly unique in being an early example of truly 3D combat.
Uncharted Waters, and even more so, it's sequel Uncharted Waters: New Horizons is a combination RPG/Tactical Strategy/Economic Simulator/Open World Exploration that has a lot of depth and complexity.
If we delve into the realm of Super Famicom games, Clock Tower is a survival horror that's legitimately frightening
The Donkey Kong Country Trilogy are of course excellent
Lemmings 2 is an amazing puzzle game.
All in all, the SNES has a solid library and there are few games that are totally unenjoyable. Pit Fighter is one of them. Possibly the worst game on the console. Don't play it.