IMO the most inspired software is the implementation of the vision of one person who had an artists/visionaries clear idea of what they want to create, who listens to input and brings in new ideas from others, but has absolute control over the decisions.
Servant leaders of software projects I’m guessing has the potential to lead to somewhat ordinary software.
It's good to have humility, but that's true for individual contributors, not just leaders.
As you point out, if a leader is too humble, at especially at Big Corp Inc, products can end up designed by committee, an ugly Mr. Potato Head that everyone hates.
It'd be nice if success required 1-3 specific personality traits but they can't be correlated exactly. But this kind of "If you do/have X, you will succeed" articles will probably always be popular.
I guess someone has to tell the Agile people, who are obsessed with rules and formalisms, about this.
Leaders need experience to cope with different situations. If a team wants a good leader, it should choose him/her based on his/her successful projects instead of relying on FotM Agile concepts and the candidate‘s willingness to adopt them.
Those patterns are designed to help groups work together more efficiently, not lord over them like the gods of Olympus.
Assuming you've already explained your frustration to your manager, might be time to seek a new opportunity...