lose horribly, get most of his side killed, and run to a far off corner to lick his wounds where eventually he is certain to die.
The role might be more comparable to Mittens except I can't think of anyone in all of EVE who is more different than Stannis, so it just doesn't work.
Most of the best comparisons are for characters that hit prominence in the next book/series or two.
Durrhurrdurr = Walder Frey, unless Razor makes a separate peace in which case this could be Fred0 or whoever is running the joint up there now
Elise = Jaime Lannister, always wins and endlessly loyal despite everything that happens
Sir Molle = King Aerys, should be self explanatory
Mynas = Balon Greyjoy, took his shot, had some glory, squashed flat, still around working steadily away at his goals
Imperian = Ned Stark, old, gets into the fight, mostly gets kicked around thanks to having no one dependable to delegate to