Ideally I want my technical manager to balance himself between involvement in the team, and extracting himself from it. Tough ask I know.
I want him to give me control over my own problem domain - a free hand with the respect not to be looking over my shoulder - so long as I deliver on my commitments. That means I get to write my own classes, not flesh out his stubs.
I want him to have a realistic view of what is happening within the team. I need him to understand where the blocks are and why, and to know that the answer isn't taking control of anybodies keyboard, nor asking others to do so.
And fundamentally I need him to stay current in technology. This doesn't mean he has to be coding per se. Being involved and keeping fresh in methodologies and high level concerns like architecture, project management, testing tools and practices, and keeping a weather eye on future tech is probably better. What is unacceptable is that he stops learning where he is and the rest of us march to that tune forevermore.
Oh, and I also (is it too much to ask?) want him to involve me, and everyone else in the designs. I am not a mindless extension of him, I need to have creative input. Make it a discussion, not a task.