Honestly I think you need to experience a couple of schools to tell. DDs have attended 4/5 primary schools.
I would say school 1 was good as it had supportive community, high academic standards influenced by the intake, and small class sizes which meant extra support for struggling pupils. But it was rubbish at communication and the small size caused friendship issues for the older pupils.
School 2 was very imaginative and a very diverse pupil body which they celebrated. However most of the pupils used the school buses and the parents were very disconnected from the school. But the school buses meant the pupils learnt organisation at a younger age... they were the ones looking in lost property or remembering to bring stuff home even in reception.
School 3 was very sought after... but I just didn't like it. It was still in its rather cramped Victorian buildings, had no real playground or sports facilties, they had to use the Church for anything bigger than a year group assembly. But it had high grammar school entry... It just wasn't right for my DD.
School 4 was very inventive to enable participation for pupil premium students. They did fundraising for trips for example rather than charging the parents the full amount. They attended this school during Covid. The school did amazing for those in school and for support for struggling families. But that left no time for those at home. My elder DDs teacher managed to destroy all her self confidence, but younger DD did very well there
School 5... I've not found any major complaints yet. They seem to have a magic money tree as the 'extras' are fantastic. Communication hasn't always been the best. DD1 has flourished there. DD2 is doing well too... they noticed she was struggling with friendships etc and have made a real effort to get her to a happier place.
I can look back and compare and pick up on what was a minor foible and what was an actual problem. The number of schools was due to being a Military family, not problems as such. But we might have withdrawn DD1 from school 4 if we hadn't moved as she was getting more unhappy.