Cartwright. Not because he was a hero, but because his all-too-human betrayal enhanced the drama instead of keeping things bland. Plus, I like Brock Peters.
There were people in the US military who continued to think of Eisenhower as "General Eisenhower" even after he was elected President.
Admiral Alexander Marcus. It takes balls the size of a solar system to think you can blackmail Khan Noonien Singh into building ships and weapons for your war against the Klingon Empire.
I wasn't impressed with Hanson. In BoBW, Hanson looked and sounded like he just woke up from a nap. He came across like an old geezer, like he had one foot in retirement. I don't know if it was due to the acting or what, but the performance was lousy imho. I found it hard to believe that Hanson would inspire confidence in Picard or anybody else.
Admiral Ross, easily. I also like Admiral Forrest and Admiral Cornwell. If Kelvin Timeline Pike counts, he'd make my list too. If we can count Commodores, I was a fan of Wesley and Stone also.
It's the same with other generals who became president, Generals Washington and Grant immediately come to mind as being better known as military officers than elected officials. Washngton being the "father of our country" comes mostly from leading the military during the revolutionary war than his time in office.
Gotta love that Admiral Quinn, Picard's old buddy who got taken over by a parasite, beat the tar out of Riker, threw Geordi through a wall, and probably would have taken out Worf too. "Vitamins, they do wonders for the body."
Admiral Maxwell Forrest Admiral Shran (ROFT novels just to break the human lovefest) Admiral Alynna Nechayev Admiral William Ross
Admiral Alexander Marcus followed very closely by Admiral Maxwell Forrest. Also, where is everybody getting Admiral Necheyev's first name is "Alynna?" Was that ever stated onscreen?
"Chain of Command, Part I": PICARD: (reading) To Captain Jean-Luc Picard, Commanding Officer USS Enterprise, stardate 46358.1. You are hereby requested and required to relinquish command of your vessel to Captain Edward Jellico, Commanding Officer USS Cairo as of this date. Signed, Vice-Admiral Alynna Nechayev, Starfleet Command. Computer, transfer all command codes to Captain Edward Jellico. Voice authorisation, Picard delta five. http://www.chakoteya.net/NextGen/236.htm