For example if the manager is very hands-on, goes into the details, produces proper mock-ups, flow diagrams, and everything is properly documented: This type of manager can actually accelerate the development process significantly since developers now know exactly what to do.
With this type of manager, as a programmer, you have to write exactly what he wants, and it's completely demotivating: the programmers cannot take any initiative.
A manager must be available.
Instead of mock-ups, diagrams, etc..., he/she must be available when the devs need him/her when some "obvious" feature is not written in the specs, or when to validate this or that feature.
If the manager is never available, because he/she spends his time detailing the process or spending time in meetings, his/her team will stop producing.
But again, this manager has to really know what he's doing, and have some serious programming experience in his past.
Absolutely no !
Programming and managing require quite different skills.
Managing requires to understand human nature while programming requires to understand computer's logic.
How could these be compatible ?
Let me guess: you are a managers' manager.
You prefer to work with people who make you believe that everything is predictable.
Am I right ?