The original Star Trek was Roddenberry's vision of utopia. The benevolent dictator always makes the right decisions. He's surrounded by his loyal band of perfect lieutenants, who apparently have zero desire to advance, and have no flaws at all. Any and all of them are willing to sacrifice themselves for the others. None do anything bad (unless it's a plot device with an explanation that absolves them).

Don't get me wrong, I've enjoyed watching ST very much. Just keep in mind that that it's a fiction.

Picard viewed the power of leadership as, foremost, a responsibility. Every action was careful, deliberate, and well advised. Some later Trek shows (e.g. Voyager) turned captains into geniuses who knew more about everything than all of their underlings. Picard was not an expert in most things and needed his staff to advise him. Once he knew the options and consequences, he shouldered the responsibility of the outcomes, but as a leader of a crew, not a genius with compatible lackeys and minions around him. It was a realistic take on leadership that simply doesn't appear often in television or movies.

Stewart, of course, was not Picard. It's too easy to conflate actors with their roles. However, actors do often help shape their characters, and Stewart's ability to give a thoughtful, diplomatic, and prudent character such incredible power and presence is likely what made Picard possible. The showrunners didn't need to strap a phaser to his thigh and drop him into every away mission to make him compelling because of what Stewart was able to accomplish as an actor sitting behind a desk.

[0] https://youtube.com/@theartofstorytelling1

Really high quality writing.