When Freya was younger we looked round all the schools in the area we had moved to, having been told that we wouldn’t get her into the ‘best one’ as it was so popular and full.
We narrowed it down to two alternatives, and then let Freya decide which she would prefer, knowing that we were happy with both (even though neither were ‘outstanding’ with Ofsted). Both very friendly, a bit untidy, but with happy, busy kids.
Freya made her choice and was very happy at her new ‘school in the woods’!, and then two months later, we were told that a place was available at the ‘best school’ and would we like to look round. We duly went along, and were shown a spotless school with amazing facilities, and well-behaved children.
Then we looked more carefully, and saw the Art room that was mostly used for maths, a ‘Child of the Week’ chart, a sign telling the children that they must do what the staff tell them at all times, and - and this is what did it for us - a member of staff looking at all the paintings that the kids had done for a competition to have their painting as the school Christmas card, and telling the lady who was showing us round that ‘they’ll have to do them again - none of these are good enough’. I will never forget that! In fact, even DH hasn’t forgotten and that’s saying something!
In any event, Freya’s chosen school was good to outstanding by the time she was in Y6 due to the arrival of a brilliant and with-it headteacher.
I would go with what makes you and your children comfortable.