I'd figure as we have a thread for the NES and its 800 game library. I'm sure with the SNES larger library, we can scavenge a few gold nuggets.
I'll start:
Pocky & Rocky -Lovin' the game. Like an overhead contra except with cute, Japanese cartoons. Best played with a friend.
Twisted Tales of Spike McFang -Another niche game with anime-like characters (and I'm a sucker for them). Playing as a kid vampire in training, you explore an overhead world relying on your hat-throwing and tarot abilities to save the day.
Secret of Evermore -Another one of Square's sleeper hits that still goes unnoticed. It had all the makings of a kid's imagination.