On the topic of memorable FF protagonists, I find Ramza from Tactics to be very memorable. Not so much because he is unique as Ramza is a fairly typical noble hearted virtuous good boy hero character, but because he in some ways succeeds and fails at the same time despite following a lot of the usual story beats you'd expect from his sort of protagonist.
When you put it all together, Ramza gets fucking nothing but personal satisfaction that he did the right thing while in contrast his foil in Delita gets effectively everything despite him doing so many bad things to get there while doing little to handle the coming disaster. As without Ramza, Delita's rise to power would have probably gone up in flames by what Ramza put a stop to. It feels so unfair and not really the super typical heroic ending where Ramza would get the girl, get his honor back despite everything, and everyone praises him as the Hero of Ivalice or some generic title like that. Ramza is considered a traitor and a heretic, his house is dead by his own actions as his last name is forever ruined, he left behind everything he had, and all his good actions are erased from common place history with only one man knowing the truth.
Delita gets everything he materially wanted and to me ends up miserable anyway regardless of all his efforts to get past his original misery, while Ramza gets nothing but at best personal satisfaction. If he properly foils Delita and we follow his personality then I believed it is implied that Ramza feels satisfied and content despite it all. I think that idea fits with this type of character and embodies the idea that knowing you did the right thing is its own inherent reward, as in a way we all have to live with ourselves in the end. Delita may be an asshole, but I don't think he is sociopathic or narcissitic enough to feel he had done a good job by the end. Ramza not being rewarded for his efforts like Delita was feels more in-line with the virtues he genuinely cares about.
Delita's final line asking "Ramza...what did you get?" or "Did you get your end in all of this, Ramza?" depending on the translation is just such a great way to cap off Ramza's character.