Op only skim read, it all depends on what you want to achieve for your dc and what you can personally offer and then, what's affordable and so on.
Many many schools around me growing up were failing dc left right and center including my older siblings so dm moved heaven and earth to get me to a privately school.
It didn't meet all my educational needs however because I'd lost so much time already at a state primary.
It's hard to quantify what it offered because unless you've been in a comprehensive situation it's hard to compare.
I could say my dd comp has poor pastoral care and another poster will say theirs is amazing.
A smaller school may offer a more personal experience, a more bespoke experience and in usually more quirky nicer settings.
I'm extremely sensitive to my environment and I deeply appreciated the older buildings, and beautiful grounds as well as the smaller classes and feeling more safe in a smaller more homely school.
My dd is now at the local comp and it's good.
The teachers are good, I was impressed at pe, and she's doing OK but I'm moving her.
The reasons are the schools response to lock down and how she was abandoned for months which has damaged her views on education.
Other niggling issues which would be outing to mention, and over all it just being good.. The place I'm moving her too is exceptional, it seems more invested, more caring already and she's not even started.
I already know more about her future, what's going on, smaller details than her current school I even know the pastoral team.
It's a grammar and it's got a reputation for being hot on pastoral issues and being caring because the ethos is, a happy child is a successful child. Her current school fails those with sen and has no interest in feedback or bonding etc or wanting to know where it falls down.
Maybe she's going to get the same good grades in both places, but I want her day to day experience to be more han just a number and somewhere where she is a person with needs.
Also the idea she would be better off making local friends never sat well with me, infact it made me feel suffocated.
I enjoyed visiting different places to meet friends, and when I was socialising properly I had different friend groups in different places which I loved.
I thrive on variety..
I don't like the samey approach to comp education and the factory line side to it, with zero accountability.
We don't have a good income but if we did I would assess all the possible options and find the best one for each dd, that may be state or comp or private or grammar.. Each child may need different things and I would try and keep an open mind with no political or pre conceived ideas.