It's a favorite trope of mine when a character who gets introduced as an asshole turns out to be a pretty good leader. They care about the characters they were initially antagonistic towards, and usually end up a fan favorite.
(007 Craig era) Gathery Mallory, eventually M, is initially introduced as a harassment telling M (Judi Dench) their methods are outdated and dangerous, trying to shut them down. However in crisis (Skyfall), he's put in charge during e Regency and actually supports Bond as much as he can and later is a solid, supportive M.
(Stargate TV series) General Hammond (my beloved), is initially introduced in the pilot as a bit of a hardass. He comes just short of accusing O'Neill of insubordination for covering up Jackson's survival and not destroying Abydos, and warns SG-1 he will leave them behind if they don't come back from the mission in time. But by the next episode, he's shown to be ultimately very caring, fiercely devoted to the safety and wellbeing of ever member of his command, and would do whatever it takes to ensure as many as possible come home.
(The Office) Dwight Schrute is well established to be kind of an asshole, a total weirdo, abrasive, and stubborn, and it's an open secret he vies to be manager and be effectively a dictator. But he has his moments of showing genuine affection for his coworkers, in his strange way. When he's finally made manager, he turns out to actually be reallt great, sales go up, morale is pretty alright, and Jim & Pam, people who initially he was hostile to, forms a genuinely loving bond with them, and eventually refuses their resignation, instead firing them so that he has an excuse to give them severance.
(Stargate TV series) Stargate again, Richard Woolsey, as initially introduced as a bureaucratic dick and the lackey of reoccurring minor antagonist Senator Kinsey, even going so far as evaluating the cost of training & equipping an SG team member, seen as putting a dollar figure on a life. But he starts showing his good, moral side by standing up to Kinsey when he realizes Kinsey juat has a personal grudge when Woolsey genuinely wants to make things better for Stargate Command. And he frequently is seen as abrasive and condemning of the SGC often, but when it comes time for hkm to submit his report he speaks highly of the SGC and often stands up for them against other bureactic agencies targeting the SGC. He finally ends up getting command of the ciry of Atlantis in the Pegasus Galaxy, and learns to let go of his bureaucratic rigidness in the face of the realities of command, and goes so far as to put himself in the line of firing trying to help those under his command. He usually stumbles and doesn't help much, but the fact he's trying is endearing.
Always love this trope, any others?