It really depends on the organization being led. Vision is not something you can easily outsource or task subordinates with. I mean one of the classic leader types would never set himself up to fail in early days SpaceX.

What a startup, a market leader and a government organization need are distinct types of leadership. Sometimes there are prodigies who can do two of these. Musk did.