Here's the thing, one does not have to be a tyrant to be an effective leader. One does not have to be nice either. There is a line. The effective leaders can be tough, demanding but take care of their people at the end of the day. You don't have to like them but you can respect them. IMO, they must also possess the technical expertise to lead folks from the front. As far as aviation goes, that means from the cockpit. My last operational CO I mentioned earlier had about 2000 flight hours as CO....too many staff tours it seems. For example, my first few CO's were cockpit only types, when it was okay to do so had between 3500-5000 flight hours depending. My first operational CO broke 5000 hours as CO and your first filght in the squadron and to the boat was with him. At night to the boat, with him. He led from the cockpit. This low time CO came into OPS one day and said he was no longer flying to the boat with nuggets as he felt uncomfortable. I was in OPS (I was the training officer at the time) when he came in and told OPS as much. I heard it with my own ears. Are you kidding me? You're the f'ing CO, act like it. Lead from the front.
I knew another officer, a fine leader, flew C-130's out of Antartica for his first tour then became an E-2 pilot. He was one of the last officers to make O-5 when staying in the cockpit was okay. He had over 5000 flight hours when he retired. He was old school but damn, could lead from the front. Yeah, a heavy drinker, partier who broke his department heads thumb at a party for calling him out. However, if there was bad weather, a questionable plane, whatever, he would take the flight. I remember a dark night over Choctaw in P-cola where there were 3 E-2's and 2 C-2's in the pattern. The tower was trying to switch to the opposite runway, screwing up big time. Stacker's gruff voice came over the radio, took charge, made it easy. We all went drinking one night as a det and of course didn't designate a driver....all of us were drunk. He took care of it though I won't say how. He was a screen for a tyrant CO. He just had an uncanny ability to lead people and was one of the best sticks and ball flyer's I had ever seen. Granted he didn't drop bombs but he was one of those guys you would follow to hell knowing you weren't coming back. Yet he did not make command....a shame. Yet my last CO was a guy who didn't want to fly to the boat with nuggets. Rarely came out of his office...always on email...never spoke at safety standowns, etc. I bet he was one hell of a staff tour guy though
.