Dark Half
Dark Half is actually one of the more unusual and challenging RPGs available on the Super Famicom. It's also a major departure for developer Westone, being one of only a few RPGs by them and definitely the most macabre title to bear their name.
The game begins typically for a mid-nineties RPG. You play a lone paladin named Falco on his way to stop the return of an evil force sealed away long ago. Despite invoking and taking on the persona of his heroic god Roda, he fails and the demon king is released. Standard set up for this kind of game, however, after a brief scene where the demon king's earthly host (named Rukyu here) assembles his servants and prepares to find and kill Falco/Roda for good, things go in a different direction.