I have worked in two extremes of state schools.
One was top of the league, leafy Derbyshire suburb, highly over subscribed school (even from catchment), loads of parental support and contact, etc.
Other was near bottom of the league, failing in Special Measures, fail.ing on all areas inc management, pupil behaviour, etc. although did state many teachers were doing a good job in very difficult and unsupportive circumstances, many parents not bothered (3 out of a potential 80 or so of my Y9 pupils turned up to parent's evening for example).
The pressures on me as a teacher were very different.
The first school was good pressure though - very challenging academia wise, planning and prep, marking, challening the pupils work wise, keeping up with parent's demands, etc.
The pressures in the second school I found so demoralising - infact as many of you know, I left teaching for good after the experience. All my OFSTED and observartions were very good and excellent, yet I felt I did virtually no teaching. I controlled, with varying degrees of success, a class of children where a significant majority just didn't want to be there or be taught anything.
As a parent who does have the opportunity to choose, I would always select the school that best suits mine and my child's needs, wherever that may be.