I had two that did. Both wanted small schools (although one realized that 1200 was just TOO small). I felt claustrophobic when we were touring these small schools but onward we marched. One ended up at a 3500-4000ish on campus population (many more were on internships or away from campus), the other at a 10k flagship. By junior year, both wished they were at bigger schools just to have more classes to choose from (not necessarily in their major). It was fine, they both enjoyed their time at their schools, but a 16-17 year old picking a school and thinking they wanted something small is different from a 20 year old who has been there for 3 years. Both knew their professors, both participated in a lot of activities and made the schools work.
I would have been miserable at a small school but I tried to let my kids pick what they wanted (with guidance) but finances played a part in the selection too.