It's interesting that you have experienced both sides of the leadership problem space. Honestly a bit glad to hear that others share my experiences and that I'm not just unlucky or something.

Also, oh my do I ever have an extremely similar experience of an IC-type engineer going into a leadership position and trying to "engineer" it: put all teams, sprints, tech visions, growth frameworks, etc. in huge spreadsheets. I look back in jest now, lessons to be learned!