Great managers (a) want to help and (b) can help.
When either element is missing, it can get problematic. Managers who want to help but cannot end up getting in the way in time. And managers who can help but don’t want to are not fun to work with.
But, between the two, I’d pick the former over the latter.
And either way, it pays to choose wisely.