And a clear idea of why the objective is important, or the access to inquire about that. Without the ability to know why a business goal needs to be accomplished, its too easy to start sliding back into asking for solutions rather than objectives.
I am myself for sure not a "scary-smart" person, so it means that I basically will never be on a successful team?
I prefer the answers to this question that apply to mortal developers.
In software, a manager's job is to help plan work and shield the team. It is critical that they can do this diplomatically with their peers. Planning involves career guidance, budgets, meetings. If you don't have someone doing those functions properly, the dev team is inundated with distractions.
Scary-smart is buzzwordy and really isn't needed for a team doing CRUD apps of some kind. You need self-sufficient competent people not some "rock star" or "scary smart" person. There's a reason why stereo-types are there indicating those types are hard to work with.
Always has been. Always will be.