If the father still lives in NY, then son will probably qualify for in-state tuition at SUNY. It’s a great deal. There is a SUNY school for anything that anyone would want to major in.
As for UConn, he likely would get “branched”, but I have heard of people who were admitted to a branch, having been able to negotiate their way into starting at Storrs. Also consider the Connecticut state colleges (CCSU, ECSU, WCSU, and SCSU). I’ve heard that if you start at a UConn branch, they want you to finish the two years that are available to you there, and won’t let you transfer early to Storrs unless there is a compelling academic reason to do so. But if you start at a Conn state college, and earn the grades, they’ll let you transfer to Storrs sooner. So if the goal, ultimately, is Storrs, might be best to start at one of the Conn state colleges and transfer to Storrs after one year.
Those grades/SAT likely won’t even get him into UMass Amherst, and he definitely wouldn’t get merit money, so it would be at least 55K/yr.
He might be able to get some merit money at a much less selective private college. Take a look at the threads for B students (although he’s really a C+ student). But I cannot imagine any of them offering him enough to make it cheaper for him than a public school in NYS, or even in CT. Honestly, SUNY is his best deal, at less than 28K/yr total, and next UConn, at just under 32K/yr total. Cheapest option would be Conn state college living at home, then transfer to Storrs. Of course, the REALLY cheapest option is getting his associates degree from community college while living at home (a motivated, hard-working kid can get it in 15 months (two summers, a fall, and a spring semester) and be at Storrs within one year, as a junior. But it sounds as if you’re looking for the full college experience for him, at the best school he can get into, at a cost you can afford. That’s going to likely be a SUNY school.