but more often it means trying to steer management towards implementable solutions and being able to suggest things that give the other CXO types options they didn't know existed.
This. I have dealt with enough of c-suite to know they can't focus on details, and they can't be told "no" except in very sparing circumstances. What they want is options. They have told you, directly or indirectly, what the business wants to do and you and your team need to figure out how to do this.
The CIO does this at the pinnacle of strategic levels. Directors do this with a touch of execution mixed in. Project managers/managers do a heavy dose of translation from strategy to execution, and business analysts/programmer analysts finish the job of translating into details. Its a continuum.
To me, the worst leaders are those who do exactly opposite of what many of you pine for: Stick their noses in details well beneath their level, resulting in micro-management. That is a reflection of distrust and "mightier than thou" which does nothing but piss people off and murder morale.
I'd wager heavily that a desire for CIOs who know the finer details and talk through them often haven't worked for one. I have and it was THE single worst working experience I've had.