I'll throw someone that most people won't recognize. Dhaos from Tales of Phantasia. He fits into both Motive and Mystery. You don't know much about him, other then he started attacking cities and killing people at first, but later you learn that there may be something more to it, that he has to have a reason for it. You learn everything in the ending, won't spoil it for you.