An important function of fiction is showing us things to aspire to that are not quite possible in real life.

> It's easy to make a fictional ideal leader.

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.

George Washington routinely abused the office of the presidency and ignored provisions of the fugitive slave act where he compelled members of the Treasury Department to kidnap a free African woman, Ona Judge, in New Hampshire multiple times (failing each time).

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.

The US military does extensive leadership training for officers. It is based on a thousand years of experience. None of their training materials consist of Star Trek fictional scenarios.