He's fictional though... It's easy to make a fictional ideal leader. How about real life examples? "Dalinar Kholin taught us what good men do with power" vs. "George Washington ..."
Is it? Another comment in this thread (and I'd agree), it's easier to make a story of relatable bumbleheads.
People have a special place for Picard as a leader that they don't have for other people. Picard stands out even over Kirk, Sisko, and Janeway. Or Mal from Firefly, or O'Neill from SG1. If it's "easy", then what other character comes close?
Most attempts of fictional ideal leaders are just mary sues, or are never actually tested. And the most common of the latter is that their leadership aspect is simply one dimensional.
I'm not saying the other leaders are bad characters or bad leaders. But I could definitely see all the other characters would have a voice in their head saying "what would Picard do". Well… and then reject it, especially Mal.
I don't think hero worship is acceptable in any form. We shouldn't be elevating individuals above us but championing how capable any of us could be if the time comes.
- Col. Terry Virts, USAF
https://www.smithsonianmag.com/air-space-magazine/star-trek-...
In particular, I think (I don't know for a fact) that the military emphasizes that the commander not be best buddies with those under his command.