Talking to my DD's school (recently Ofsteded) they found the process a lot more supportive than expected. I suspect it relies a lot on the individual inspector. The main focus seemed to be safeguarding (rightly so IMO).
I think it should be more cooperative and it shouldn't be so long between visits either. Especially for schools formerly outstanding, there's such a long time between inspections that there's the potential for things to go badly wrong. Maybe more frequent, more cooperative visits, backed up with resources if changes are needed, would help. Of course this would require investment in education.
The main problem is that budgets have been cut to the bone and there aren't enough staff or resources to run a school properly, at the same time as ever more ridiculous targets are set.
I wish people - not just teachers - would start standing up and saying 'these targets simply aren't achievable with the budgets we have and if you want us to safeguard properly too' - of course no-one wants to admit that, but it's true.
The scandal over sexualisation of children via RSE from outside organisations - some of which is truly horrendous and clearly falls foul of the 'abuse' definition in KCSIE - is a symptom of this: schools outsourcing things they should be doing in house.
A lot of targets also seem to be plucked out of thin air - I've never established whether the 97% attendance aim is actually evidenced based or achievable for an average child. My completely healthy child who nevertheless catches loads of bugs in school is often below that target. I really feel for those with medical conditions who simply can never hope to meet it.
All the wasted time chasing up children with attendance below the target who are just off sick and catching lots of bugs. And maybe that does affect education - but what are they doing about it? Air filtration and ventilation in schools to reduce the spread of disease? Forget it.