I would say that the majority of CEO's are overpaid.
We can look at former twitter CEO Parag Agrawal as evidence of this. Parag was CEO of twitter for more than 12 months and was unable to implement anything more cutting edge than an edit button which is trivial technology and code. CEOs of other big tech corporations also have not done much to innovate or progress their industry. The efforts of some like Mark Zuckenberg (multiverse) also stand out. There is a question of whether CEOs are deliver value equal to what they're paid, which could be in dispute atm.
When Bill Gates was acting CEO of microsoft he admitted that the only thing he did was read and answer emails all day. The job doesn't require specialized knowledge or skillset in most cases. And I would guess if most knew what their job entailed they wouldn't think that it was deserving of $10,000 an hour salary along with the considerable incentives and golden parachute arrangements they enjoy in their contracts.
Parag Agarwal proved himself in lower positions and was then promoted. He was not just picked from another company and offered the CEO position at Twitter.