This is very helpful info, and you did a great thing by doing the local tours of a variety of schools!
CS admissions can be tough, and you’re right that it can make admission to a given school a super-reach (e.g., Purdue and UIUC).
I think he’d get in to CS with merit aid at all the schools I’ve mentioned (Case is a wildcard though).