If you’re gonna go for quality SNES RPGs that show the console shining, you’d be better off with Terranigma, the Final Fantasy series, Tales of Phantasia, Chrono Trigger, etc, etc.
Most of them could just as easily be NES/SMS games with slightly tuned down graphics; they don’t push the SNES in any meaningful way. As mentioned, that’s an intentional decision and not intended as a slight.
[1] Although notably, they did release a demake of DQXI into a Super Famicom-style game!
Obviously a game for modern consoles is going to be far more advanced than an NES game; even while still being quite conservative.
Seiken Densetsu 3 is good too. Only released in Japan but got translated by fans to be played on emulators. Now part of Collection of Mana for Switch and officially remade in 3D for Switch, PS4, XBox and Windows named Trials of Mana.
Single player it was less fun than I remembered, multiplayer it was awful. SD3 is a beautiful game, and very overrated.