Size is less important than the quality of programs, the curriculum generally (what majors are offered, for example), and the “quality of life” (which I think of as student life, atmosphere, school spirit, extracurricular options).
My older kid applied to colleges ranging from small liberal arts colleges to mega-universities. He ended up in between, based on the quality of the programs and the location. But he had a good range of choices after the acceptances came in. That worked out just fine, after a couple of campus visits.