I don't think it's that CEOs must be "bad people" (for want of a better description) to succeed.

I think it's more than CEOs have to be able to upset people to get the result they want. It also helps if that result is beneficial to themselves or the company.