What is true is the myth of individual efficacy. That a good CEO will have a successful company, and that a successful company is a sign of a great CEO. The reality is obviously that there are countless factors that affect company performance.
It's not that people think they are special, it's that we are very bad at correctly apportioning responsibility, especially when there is also a power imbalance that extends to determining that apportionment itself. We don't instinctively seek royalty (as in we assume leaders are special as a rule, though obviously in some contexts/positions we do), we seek simplicity (and pinning everything on a single leader is about as simple as it gets).
