I don't believe one is necessarily better than the other, though different businesses at different stages of their lifecycle will definitely need different style CEOs.

Broadly, I tell CEOs I deal with that there are only three things they need to focus on:

Managing in Context (ie, the bigger purpose)

Coach don't Play

Managing the Energy in your Business