ferraroso named some good ones
i really enjoy going thru SFC games, so I can name a few that I think might be worth your time
i think there are zillions of good RPGs so i won't bother with those
super tetris 3 (has 4 player support)
tetris battle gaiden (weird head-to head with powerups)
twinbee rainbow bell adventures (think sonic + rocket knight..but with classic twinbee color scheme)
pop'n twinbee
bomberman 3, 4 and 5
super family tennis (4 player support)
any of the power pro baseball series.. they are kinda tough compared to most baseball games from 16 bit era but there is a lot of text due to the story mode and the gameplay itself is quite unique. they have no equal in terms of creativity with baseball on SNES
battle cross (top down racer with 5 player support)
those are more arcade/sports style games, but hey, gotta have variety!
check this guy out...
https://www.youtube.com/user/1SNESdrunkhe is only reviewer i can stand to listen to, and he has a few different ongoing series on super famicom games. might be just what you are looking for. his vids are short and to the point for the most part