@ Alex: Admittedly, I often use it at the end, but there were some times I used it in the middle of battle when the winner was still in doubt just to remove (sometimes obsolete) orders from some ships among a crowd, or to remove some Assault/Defend or Engage order from a bunch of ships when that is no longer becomes necessary.
@ TaLaR: I have about four frigates dedicated to pursuit. Those are usually the times when I do not solo fights with one ship. That said, dividing my already minuscule fleet into various roles encourages me to solo nearly every fight. Five or six ships to kill 40+ ships (AI cannot fight such bad odds, but the player can), four or five frigates for pursuit, three Atlas to haul, three tugs to make my Atlas faster, and the rest (up to about ten or so) as spoils from shopping or boarding.
But, yes, officers are generally more useful when you can use them in any situation. (That is one reason I do not want to train ten Timid officers for a dedicated Pilum spam fleet of Vigilances.) That is less of a concern if the player plans to solo every fight that matters and use officers mostly to keep CR maxed at 100% instead of 80%.
As for my choice of officer personality: My favorite tends to be Steady. I have about two Aggressive, one or two Cautious, one or two Timid, and the rest Steady.