Someone that actually manages things and takes away a lot of the communication between devs and users/customers.

Someone that has a broad overview of things and keeps things in line between devs in different teams, QA etc.

Someone that tackles existing or future problems hands on, by clearly communicating them and prioritising and assigning them to the right people.

Someone that makes sure, that requirements/backlog etc. are always in a workable shape.

Most managers that i work with lack in one or multiple of these areas.

Some managers i worked with do none of these and just report numbers and budgets, while avoiding to do anything useful towards the actual project/product.