The truth is that there are truly important CEOs without whose leadership their companies would flounder, stagnate, or die.
At the same time I've been wholly unimpressed with the leadership of the vast majority of CEOs I've met, not just from an outside looking in perspective but from a working closely with them and meeting them personally perspective.
I've met any number of VPs, COOs, CFOs, etc. that are extraordinary leaders and I've met mostly CEOs who exploit those people and the value they create for their own personal gain.