Go for the best school you can for your child, and reassess which school at each level. Our experience is that in England at least, most people are entrenched in one type of school.
Although everyone talks of being open to any type of school as long as it is "good" in practice they buy into a particular type of school.
So develop a tough exterior, because whatever you choose you will upset someone.
With my elder DS we upset everyone, as his schooling went like this:
(1) State primary, our local one, which everyone said was failing. Having secured a place at another state primary universally acclaimed as good, we actually chose the local one, as it seemed to us to be the better school, and indeed the best in our area including private.
So we upset friends who are committed to private.
(2) Passed 11+ as well as entrance to highly selective independent school. Chose grammar school.
This choice seems to have upset nobody.
(3) Sixth form at Eton college.
Upset just about everyone....even those committed to private! Presume this is because Eton is perceived as too posh?
Every decision was taken with a great deal of thought, and we regret nothing. Choosing the best education for your children is nothing to do with winning the approval of your friends.
The dreadful truth IMHO is that most people don't carefully define what they mean by "good" as in "a good school". They are more influenced by social cachet, political mantra etc.
Ask people why they chose a given school for their child, and they will inevitable reply that it is a good school. Probe further as to why, in their opinion, it is good and they will probably grind to a halt.
However, ask them why they bought their current car, or why they booked their most recent holiday, and you will perhaps get a deeper answer.
Sad but true.