A great player that became a great HC is an outlier, really. Position coaches, maybe.
Lombardi, Landry, Noll, Shula, Walsh, Madden, Parcells, Johnson, Dungy, Gruden, Cowher, Reid, Bellichk, Shanahan, John Harbaugh, Flores...all won one or multiple Super Bowls but were at best marginal players...