I encourage you to check out Denison. It checks a lot of boxes:
"He is used to being around grinders but is not really a grinder himself." - Denison's environment is very collaborative
"He is fine with cold, loves skiing." - There are several small ski resorts 1-2 hours from Denison
"involved advising and with easier to access to internships" - Ranked #2 for Career Service by Princeton Review.
"well-defined college campuses, dislikes the super urban schools." - beautiful campus in a small picturesque town, but only 30 minutes from Columbus for (more) restaurants, professional and college (OSU) sports, museums, an airport, etc.
"He also plays golf" - Denison owns a golf course right next to campus
"anywhere within 8-10 hours from DMV" - 6.5 hour drive from DMV
"He is a sporty, super social, nice kid, lots of friends" - sounds like a lot of Denison students
STEM - Denison blends strong STEM skills with the broader perspective of a liberal arts education. The idea is that students learn the technical side (data and science) while also developing the communication, critical thinking, and ethical judgment needed in the real world.
Sports - 1 in 3 students at Denison are varsity athletes, so it's pretty sporty but it's not siloed. Students have a lot of opportunities for club sports and the facilities are really nice.
Merit Aid - Denison has a $1B endowment and gives out quite a bit of merit for such a competitive school. His GPA and SAT would set him up well.
https://denison.edu/fast-facts
Other smaller schools to consider that haven't been mentioned and might offer merit aid are Bucknell, Lafayette, and Richmond.