Super Metroid is most definitely in the running for best non-RPG game on the SNES. I'd say it probably wins.

Secret of Evermore is another good game people seem to never like for whatever reason. Probably my favorite or second favorite game of all time.