The Black Knight from A Practical Guide To Evil, especially among the orcs. Not only is he a brilliant leader who has won the Dread Empire incredible victories, he also reformed the Legions of Terror to allow much broader recruitment. This meant that the orcs could be actual soldiers with proper gear, training, and opportunity for advancement rather than just hapless Cannon Fodder.
Sun Tzu's The Art of War suggests a "Stern Father" approach to leading one's men. One commentator relates a story of a general who personally cared for an ill soldier. When the soldier's mother heard of it, she burst into tears: her husband, who served the same general, never abandoned the man afterward and died in battle as a result—and now her son was going to be the same way. Chapter X also contains the line (from the Lionel Giles translation):
Regard your soldiers as your children, and they will follow you into the deepest battles. Look upon them as your own beloved sons, and they will stand by you, even until death.
Lampshaded in Dune when Duke Leto Atreides risks his life and the priceless spice to save his men, someone comments that a man such as that would inspire fanatical loyalty. It's implied that this is why the Emperor wants him dead, because he fears Leto will use his popularity to depose him. There is, however, both in- and out-of-universe debate over how much of his attitude is genuine, and how much of it is calculated precisely to evoke loyalty in his subordinates.
See also Miles Teg, a descendant of Leto Atreides, 5000 years later. While his actions are never gone fully into detail, he is so like Leto that even an awakened Duncan Idaho ghola is driven into fanatic loyalty, seeing the same Atreides core of integrity. The fact that the genetic dice have given him almost exactly the same appearance does nothing to diminish this effect. Even restored as a child ghola by the Bene Gesserit, he still inspires the same loyalty, commanding his troops while riding on the shoulders of a sisterhood Acolyte.
Surprisingly, Abaddon in Black Legion. In contrast to his personalities as pictured pre-Heresy (Glory Hound) and in 40th millennium (Ax-Crazy), in the book he's shown to be charismatic and empathic to the needs of his soldiers. He knows the name and notable deeds of every single soldier he meets aboard the Tlaloc and even manages to elicit a vague reaction from the usually unresponsive Rubricae.
An almost inadvertant example of this trope is Metellus Pius (aka 'the Piglet') of Colleen McCullough's Masters of Rome series. He fusses and clucks over his troops more like a mother than a father to make sure they are in fighting trim when the time for action comes. At first his motives are purely practical but the glow of his men's gratitude and affection gradually changes that. In the end he cares for 'his boys' as they care for him.
Aral Vorkosigan in the Vorkosigan Saga by Lois McMaster Bujold, specifically how he treats his men during the two pre-Miles books, Shards of Honor and Barrayar. He's explicity said to love Koudelka "like a son", bending the rules to keep him on as a secretary when he would have been medically discharged. If one applies this metaphor to Bothari... a little Oedipal complex? That's sorta scary how well it fits, especially his incident during the Escobaran war...
Bujold loves this trope: she also used it in Paladin of Souls - Lord Arhys is just such a man, and it is outright stated that his patron god (the Father, natch, one of the five gods) feels the same way about him.
Lord Suffolk in The English Patient is like this, especially for Kip, who considers the English sapper unit to be his real family. This is a definining feature in his backstory.
Star Wars Expanded Universe: Kal Skirata was the only family his clone troops ever knew, and he did care about them as though they were his children; he allowed his own sons to disown him, in order to keep the clones safe because they needed him more.
A rare literal example later on: he formally adopts the main characters as sons near the end of the war.
Several Jedi Generals were also as fathers to their men, the Clone Troopers, despite their origin. They treated them well, giving advice, etc. Many willingly sacrificed themselves to save their Clone Troopers.
While it doesn't come off so much in the movies, in his own way, Darth Vader — himself a veteran of the Clone Wars — is like this to Imperial troops. Despite belonging to the topmost rung of the Empire's hierarchy, Vader would fight on the frontlines with them, not expect anything from them he wouldn't do himself and was generally a very strong guarantee of success in most of the battles he led. Note that this depends heavily on whose writing him: in some stories, Vader doesn't give a single damn about any of the soldiers under his command and treats them as entirely expendable.
Thrawn, having realized that the Empire remnant no longer had reserves, became a respected - if somewhat ruthless - leader to his men, trying to spare them whenever he could and heavily reprimanding his commanders for losing them fruitlessly.
And Polly's own motherlynature shows throughout the book, often landing her in charge even when she's not technically in charge.
Commander Sam Vimes. "When your back's against the wall, Mister Vimes is right behind you."
Arch-Chancellor Ridcully. While he can be a bit abrasive he is genuinely protective of the rest of the university faculty and willing to fight to protect them. Probably best exemplified by this speech, one of the few times he gets truly angry.
"[I]f anyone has poisoned our Librarian, then, although I am not, by nature, a vindictive man, I will see to it that this university hunts down the poisoner by every thaumic, mystic and occult means available and makes the rest of their life not only as horrible as they can imagine it, but as horrible as I can imagine it. And you can depend on it, gentlemen, that I have already started work on it."
In Sandy Mitchell's Ciaphas Cain novels, Cain does his best to pose as this (and later, to pound into the heads of cadets that this is elementary self-preservation). Apparently, he's completely successful; both Sulla and Tayber, in the excerpts from their works, effuse about his boundless concern for his subordinates.)
However, whether Ciaphas Cain is a true father to his men or not is a matter up to debate, though considering how many times his biographer notes he followed this trope when being coldblooded would be more rational, signs point this being true.
One can at least argue that he makes a good example of why a commissar that encourages his men through care rather than fear is more effective. As he himself states, commissars who use fear to boost morale are for some reason more susceptible to "accidents" from his subordinates, which in turn would plummet morale to oblivion in the end.
At the same time, he is so oblivious to how beloved he is by his men - and indeed most of the Imperial Guard - that, when an assassin tries to kill him, he points out that it would have made more sense to kill other officers or the Planetary Governor - not realizing that his death would be devastating to morale.
Dan Abnett's Horus Heresy novel Horus Rising opens with the Warmaster sends one of his men, Sejanus, to parlay with a planetary emperor, and Sejanus is murdered.
The commander's grief was absolute. He had loved Sejanus like a son.
In Abnett's Gaunt's Ghosts series Colonel-Commissar Gaunt of the Tanith First-and-Only isin this role, but Colm Corbec, Gol Kolea, and to a lesser extent Viktor Hark all exhibit signs of this. In The Guns Of Tanith, several people try to persuade Gaunt this it is beneath his dignity to involve himself in the question of whether a Ghost trooper accused of rape and murder is guilty. He counters with the fact that the troopers actually win his battles, and a general is impressed by such views, which he hasn't heard in some time.
Some subordinates also show it. In Straight Silver, Raglon is deeply guilt-stricken when his first mission as a sergeant results in half his troopers dying. When Gaunt's reassurance reveal that Raglon is hiding something, and Gaunt digs for it, Raglon tries to put him off with, "I was in command, sir" before telling Gaunt that Costin had been drunk, and then tries to save Costin from Gaunt. In His Last Command, Wilder also fits under this trope, suffering somewhat because good as he is, he is not Gaunt. And Mkoll, seeing a scout whom he met only recently knocked through a Chaos warp gate, says No One Gets Left Behind—and jumps through. Despite its being cold and wrong on the other side, and the other scout's freaking out, he gets him back to safety.
In Mitchel Scanlon's Descent of Angels, when Brother Amadis tells Zahariel he had saved his friends, Zahariel tells him he was protecting his squad, and then tries to fight off collapse on the ground he had to get the squad back. Amadis assures him that he will take care of it, as Zahariel's done enough.
In Graham McNeill's Ultramarines novel The Killing Ground, Barbaren remembers with scorn his predecessor as colonel, who thought bringing his men back alive was important.
In James Swallow's Blood Angels novel Red Fury, when the Flesh Tearer Noxx gets Kayne into a situation where he can challenge him, Rafen, being Kayne's sergeant, breaks his fingers and says that since Kayne can not face him, he will take his place.
The trope is mentioned in one of the Flashman novels, which the Cain series is strongly based on. On the eve of the Mutiny, an Indian sepoy says that his old commanders said their soldiers were like children to them (in a good sense), not like the arrogant idiots now in command.
Admiral Cyrus Stableford in Tranquilium. Possibly even more so, Gleb Marin later in the novel (especially when he becomes the Tsar of Palladia). The latter actually muses in some detail on how this is a necessary component of good leadership, and makes sure to cultivate a strong bond with those under his command. Both have highly loyal crews and/or troops that support them through the political thick and thin.
In the Malazan Book of the Fallen, Dujek Onearm is portrayed as this. As Adjunct Lorn points out, "He's not just a man. He's ten thousand men and in a year's time, he will be twenty-five thousand men". When, after the siege of Pale, attempts are made on his life, his soldiers volunteer to guard his back at all times, even against his wish.
Not the case with the title character, who attempts to maintain proper distance and reserve between himself and his crew. They worship him anyway, because he's absolutely fair to them, and utterly brilliant in battle.
Atropos features Collingwood as Hornblower's admiral, who was in Real Life beloved as being kind and fatherly towards his men. After testing Hornblower to satisfy himself of his new captain's skills, Collingwood treats him with gentlemanly courtesy. He clearly hates having to yank Hornblower's ship out from under him so it can be given to a full-grown Royal Brat to preserve an alliance, does everything he can to soften the blow, and has him fast-tracked to command of a bigger and better ship (the one Hornblower commands in the first written novel).
The title character of "Leiningen Versus the Ants", despite not being military. Even facing a gruesome death from a giant art swarm, Leiningen's plantation workers refuse to abandon him, even when offered an escape route and their full pay to take it. When their only hope comes down to a suicide mission Leiningen takes it upon himself rather than having one of his men attempt it.
Dalinar Kholin cares greatly for the safety of his soldiers, and refuses to ask them of anything he'd not be willing to do himself. This is one of the first connections he shares with Kaladin.
Dalinar: Each man who wears my colors is of my family, in a way. The cloak is a simple gift, but it is one of the few things I can offer that has any meaning. Accept it with my gratitude, Kaladin Stormblessed.
Kaladin is much the same, though on a smaller scale since he's a squadleader instead of a general. He knows the name of every man under his command, and still remembers them years after they've died.
Gaz: What are they to you? Why do you even care? Kaladin: They're my men.
Subverted in The Forever War by Joe Haldeman. The protagonist tries to fulfil this trope when he becomes a major but fails, partly because he's not suited to the role but mainly due to Time Dilation he's a relic from the past who doesn't understand the language and culture of contemporary humans.
Gaius Marius is one to the Primigenia in Emperor: The Gates of Rome. A couple of his legionaries even explicitly refer to him as a father figure.
In David Drake's Northworld trilogy, Hansen blames himself for the deaths of anyone who fought on his side — because either they died following his orders, in which case he got them killed, or they died not following his orders, in which case he got them killed by not being able to make them see that what he ordered was the right thing to do.
In Robyn Johnson's Vara , Commander Hyde is this though it's most notable with the female Lieutenant Hart. Commander Jax was this with his soldiers as well, even going so far as to die alongside them
General Belisarius in David Drake and Eric Flint's Belisarius novels is this, right down to the military genius part.
The Colonel in George MacDonald Fraser's McAuslan, a quiet old man who refuses to allow his men (even the worst disciplinary problems) to be punished outside the battalion, attends all their activities, and is proud of their least successes.
The Narrator, MacNeill is one most of the time, even to the point of looking out for the eternally benighted titular character after they demobilise, but he also recognises that at some points, "paternally stern but fair" isn't the correct way to deal with a situation. One example would be trying to get the jocks to leave the pub, where "paternal" fails miserably, but bodily hurling the biggest one out the door (in violation of all regulations, self-preservation instinct and common sense) not only gets the rest to drink up and leave, but also earns him the respect of his men.
In Andre Norton's Ice Crown, one of Imfray's men, after the rescue, recounts the time Imfray saved him from a rock fall.
As shown in Twilight Sparkle and the Crystal Heart Spell, Cadance knows the name of every one of her subjects. Even study queen Twilight is intimidated, and immediately wonders if she should get some flash cards made up.
Trench, of The Accident Man, is a father figure for the protagonist, having nursed him back to health after the death of his wife, and led him to his current career. That makes the sudden but inevitable betrayal all the more painful.
In Janet Edward's YAMilitary Science Fiction trilogy Earth Girl General Riak Torrek, as someone who came from a civilian farming planet background, particularly cares for other sector recruits. (90% of military recruits come from military families, only 10% from sector civilians) In the prequel short Kappa Sector 2788 he talks a young sector recruit out of prematurely giving up on his military career with stories of how hard it was for him to catch up to the military born recruits, how often the others had to talk him out of leaving and how he made a much more embarrassing mistake during his first Planet First command job than the recruit who was mistakenly ordered to take off the front door of the then Colonel's quarters. In the same story he retires because he wants to make room for younger, physically and mentally stronger commanders who need less rejuvenation treatments.
In book one he commands the Earth Solar Arrays (this seems to usually be a quiet retirement assignment) and manages to evacuate most of the military to Earth after a sudden unforeseeable Carrington Event shuts all portals down and the radiation threatens to kill the soldiers. Mind you, he gets them evacuated in cargo ships made for space travel only, without any heat-shields, life support other than from their impact suits, or built-for-atmosphere thrusters. Somehow his crew manages to McGyver some heat shields onto those ships under enormous time pressures and land the ships with amazingly few losses.
It is implied he gets the Alien Contact programme command post in book two not just because of his tremendous experience and seniority, but especially because of his level-headedness, kindness and good judgement. The military needed a reliable, not trigger-happy commander who can see the bigger picture and provide mentoring when needed, all of which and more he provided to his men and women.
Speaking of mentoring, he has to reassure Jarra many times during the last two books (because she keeps blaming herself for the anti-Handicapped hate and violence her friends are more and more subjected to too) and does so splendidly.
In the Rihannsu novels Ael t'Rllaillieu often refers to her crew as her children. She also notes that many Romulan COs aren't this trope, hewing more towards the Bad Boss type by ruling through fear. Though even Ael notes that a well-placed tantrum and tirade can be a useful tool on occasion.
Eddard Stark rules the North with this philosophy, personally enacting justice and listening to his smallfolk, which he passes down to his sons.
Eddard Stark: Know the men who follow you and let them know you. Don't ask your men to die for a stranger.
Jaime Lannister in the fourth book. He's so good to his soldiers and household that even his hostages think he's great.
Gender Flipped with Daenerys Targaryen. She sees herself as a mother to her followers and is extremely protective of them.
Minor character Clement Piper is outraged that his men-at-arms are killed at the Red Wedding simply because the Freys didn't think they were worth taking hostage.
In the Warchild Series Captain Azarcon is considered like this, practically adopting his crew and encouraging them to pursue education beyond what's needed for the job. He looks after his crew.
Human (2015): Aleksander Svetoslav is an Opyri Prince who embodies this trope to both the other Opyri of his House, and also the humans of the mundane assets his House inherits after House Ustrel is wiped out by hunters.
In Alexis Carew, the title character learned to handle men first from being raised by her grandfather and his foremen and ranch hands, then getting her initial dose of New London Royal Navy training from Captain Grantham, an example of this himself. In contrast with some captains who rely on threats or force to control the men ("Tartars"), Alexis tends to win the Undying Loyalty of the crew under her by directing with a kind word and a smile and by joining in with their work. The horribly sexist Captain Neals in Mutineer wrongly infers from this that she's trading sexual favors for their loyalty. His busting her down to ordinary spacer and having her flogged for refusing to kneel to anyone but the queen is ultimately what triggers the mutiny that's been building for most of the book to that point.
"Here was one with an air of high nobility such as Aragorn at times revealed, less high perhaps, yet also less incalculable and remote: one of the Kings of Men born into a later time, but touched with the wisdom and sadness of the Eldar Race. He knew now why Beregond spoke his name with love. He was a captain that men would follow, that he would follow, even under the shadow of the black wings."
The Magic School Bus: Miss Frizzle is this to her students, to the point where the one thing she values more than the wild field trips she takes them on is their safety, as demonstrated in one story where Tim and Wanda are separated from the rest of the group and she doesn't make any attempt to pretend that was intentional.
Sandokan: The titular character treats his men very well, and they love him to the point he can (and does) order one of them to shield him from bullets with his body and he'll obey without question, even apologizing if another pirate dies in their place shielding Sandokan.
Most of the Freikorps officers in The Outlaws are like this, especially Lieutenant Kay.
Subverted in The Wheel of Time. Sammael takes very good care of his men, but has no emotional bond to them whatsoever. As far as he is concerned, he is a general, his troops are his tools, and well cared-for tools work better than ill-maintained, poor quality ones.
In The Winter War by Antti Tuuri, the regiment commander Laurila personally knows all his officers, most of the men, and seemingly mourns every fallen man under his command. Also, the narrator's company commander is said to be this, in exact words.