Agree that no one is hating on small schools. It’s individual. My D19 went to a large private (one named above as supposedly having all the disadvantages of a large public) but because of the program she was in, almost all her classes were max 20-25 students apart from a couple of gen eds (most of the gen ed requirements could be met with courses within her program). That meant she also got close to her professors, etc. A non-honors college example of making a big school small. Certain majors in a public could be similar, others won’t be.
Again, it’s all individual. Every school out there will work for some people and not for others. The important thing is the student knowing what works for them.