It’d be useful to know why some SUNYs are liked or disliked. They’d be affordable for sure. Albany is typically the one for business (beside Bing) and OP would likely get Honors college there. Stony Brook is a commutable, academically solid option that nevertheless has dorms. Geneseo is not as well-known for OPs interests but is excellent academically and has almost “private” feel imho. New Paltz has a cute town with NYC access, plus it’s another honors program near-safety.
Seconding @CMA22 's idea wrt Ursinus.
Wheaton MA would be another CTCL worth looking into.
Btw I listed Macalester as an example because you would need to fly and they’re 100% meet need, so 1° do they include flight costs in your financial aid and 2° would it be affordable?