The best manager role I ever worked with wasn't incredibly technical, although he was loosely working on getting some IT certifications at the time. He wasn't even the person I really reported to, he was just a project manager that was really on the ball. I knew if I needed something, I could go ask him real quick and he'd make it happen. If I didn't have the full specs, he'd go chase down the other teams and get them sorted leaving me to stay busy with the technical work. I knew if he threw a meeting my way we'd have a good agenda with real issues to work through, and I knew I'd get minutes sent out after the meeting to keep track of what was decided.

I haven't had many excellent experiences with project managers, but dang was he good at keeping me unblocked.