The only superstars who made good managers that come to mind are player-managers; Tris Speaker, Mickey Cochrane, Frank Frisch, Bill Terry.
Ted Williams did a remarkable job in his first year at Washington, but after that they went back to being the same old sorry ‘Nats.
If Molina is serious about managing, I think he would take a minor league job somewhere.