SNES has tons of great games, though what you feel is great will only be determined by the genre you want, i played SNES from its early begginings to its end, i know ALL there is about SNES, some of my favorite games that are more obscure and lesser known include
Hyper Zone
Super castle vania 4
Final fantasy 2
Super Punchout
All of the Top Gears (very fun racing games)
Super off road (crazy repeitive addicting racing game)
Secret of Mana
Soul Blazer
Space football
Ultra man
Lagoon
populus
Theres tons more some SNES games were just crazy in its first 2 years of existance