I want my manager to help get the business out of my way- managing requirements, keeping external dependencies on track, fussy paperwork and such.

I don't need my manager second-guessing my every decision or weighing in on my PRs making superficial complaints about style while also bemoaning our velocity.

Hands down, the best managers I've had have all been clueless about the languages and types of work I do, and the worst managers have (or think they) have some understanding of what I do.