Sure. Decisiveness, adaptability, reliability, etc. are great.
But the biggest problem is when the CEO is decisive, the CEO is engaging the team, the CEO is adopting to environment and the CEO is reliable - but the CEO is doing it all wrong. I.e., the CEO just doesn't have a clue.
As Napoleon said (and many others): whoever is industrious and stupid should be shot on the spot.
The best CEOs are the one who are lazy and very smart. Lazy? Because they will delegate their vision to other people. Smart? The CEO will have the right vision and delegate to the right people.