Which former 'greats' became good managers? I can think of Brian Clough and Pep Guardiola, but not many others.

I think most great managers were not necessarily the greatest players, such as Mourinho, Klopp, etc.