Also as a middle manager I can relate to some of the struggles. You will have potentially competing points of view from what your team would like to do and what the company wants them to do.
But also as an additional point of view. As a manager you may have worked your way up the hierarchy learning your craft and honing your skills. Unfortunately very few of these may actually relate to management but at some point you reach that level of seniority and then the company says "here's a team, I'm sure you'll be fine" and leaves it at that very little training or coaching you just now have to learn on the job. Unfortunately unwinding mistakes at a managerial level is very difficult because it invariably had that human component and sometimes we struggle to forgive and forget.