Hi OP
I have 2 dc and live in a very 'picture perfect' village with ofsted outstanding, high performing schools. It was one of the reasons we moved here.
DS (now 5.5) has glue ear, significant hearing loss at times and as a result had very delayed speech and language development.
He went to the village, very 'posh' nursery school who were awful- they wouldn't even have the speech and language therapist in, as they felt he did not have an issue- he was just lazy! (despite the fact at that point the speech therapist thought he might need a hearing aid) At that point he was not only behind with speech, certainly wasn't beginning phonics etc like many of the other children and had no confidence, he didn't really play with the others. It broke my heart.
We went to view the 2 village schools with top reputations, explained his issues to the heads that we saw and their reaction said it all- you could see they weren't happy that they might have to take a child who wouldn't give them instant good results.
So we looked around at a school in the next village which has a very mixed catchment area, much higher percentage of free school meals,SEN, English as additional language etc. The head and teachers were lovely and we decided to send both our dc there- i'm sure some of our neighbours thought we were mad but we are so happy with the school- he's now Y1 and dd is in the pre- school.
The reception teacher was beyond amazing- he went from a shy boy who wouldn't speak or join in to a happy sociable boy who finished reception either on or above target in all areas, is reading relatively fluently, writing well and gaining confidence all the time.
I would say go with your gut instinct... I am doing primary PGCE at the moment and the more I see the more I am convinced that parents and families are what drive children's aspiration levels and attitude to learning- not schools.
Our school is much less cliquey- I am well educated and switching career to my second professional career, dh owns his own business, we own a nice house and cars, went to private school, I got a first from a good uni, we are middle class by pretty much anyone's terms, but these bloody dinner party holding, people carrier driving, boden wearing yummy mummy types who exist purely to brag about how gifted/ talented/ ambitious/ multilingual their 4 year olds are are my idea of hell and I am glad to be away from them. (I do realise that that last paragraph does not do justice to my English degree or chosen career but it does express my feelings about this type of person well!)
Also please ignore posters who claim their children are held back by teachers in any school, anywhere. There is immense pressure on teachers for their pupils to perform highly- it would be absolute insanity on the teacher's part.
Good luck whatever you decide- it feels like a huge decision at the time :)