My DC have gone to both a larger primary and a smaller one. On each occasion they have gone to our nearest school (moving house necessitated the change). I genuinely think the starting point when choosing a school should be one you can easily get to tbh, given how much stress there is around parking etc I am v glad not to drive.
Big isn't always better. One of my DC hated the larger school, felt their efforts went unnoticed and they were never picked for anything - plays, choirs, sports etc, there were just so many kids that they never got their chance to feel noticed or to shine. They were miserable in the playground with older children often left pretty much unsupervised around the younger ones etc. Having a large pool of children did not = more friends at all. Similarly, although there was wraparound care, you had to book at midnight as slots were released as there were not enough spaces. The big popular primary near us tickets all their plays and concerts and parents genuinely miss out if they don't get a ticket in the ballot. It sounds hideous to me. The performances are glitzy and slick but the kids may not have a parent watching and many are lost at the back of a big chorus.
Smaller school has been transformative for us. DC feel noticed and acknowledged, all get a turn to shine at what they are good at/have an interest in. Everyone can be a librarian/captain/play leader/dinner helper etc if they want to, everyone can have a part in the play etc. Our school maybe is unusual but there are lots of clubs etc and the wrap around has space when wanted for anyone who wants it. I love how all the DC know each other and have a real sense of responsibility towards each other. The mixed year group classes mean they get to know different DC each year and these friendships have been rekindled at high school. Going from a small school to a large secondary doesn't seem to have been an issue.
OTOH, a family member didn't get their first choice of village school and reluctantly accepted the 3 form entry offer they got. It's been brilliant for them and their DC have thrived. One has some issues and benefits from the additional spaces and resources a bigger school can provide. They openly admit they were glad not to get their first choice.
There are pros and cons to any situation but I would make your own decisions and not have blanket rules. I know people who ruled out a school with mixed year groups or only wanted one that had certain extra curricular offers without really thinking through all the other variables. A huge amount of your experience will be based on the characters involved - how the school is run and how you feel about the teachers and parents as much as where the school is located or how big it is.
Best thing to remember is you can always move if it doesn't work out!