There's seriously so much truth in that old joke.
No matter what the initial challenge is, it's a CD's responsibility to dig deeper and ask the hard questions that help solve the real business problems. And, they need to be able to lead, inspire, partner, and persuade everyone to take a chance, and do something special.
That's what I do for agencies and in-house studios. Let me know if you need some help changing a bulb.