It’s really impossible to give a lot of help here without some idea of your need (or not) for financial aid or merit aid, and your child’s interests.
That said, I agree that Macalester, Brandeis, and Rochester are reaches for the kid you describe, but maybe not “way out of reach” reaches. Geography will work in his favor at Macalester, and probably work against him at Brandeis or Rochester.
I think there are three or four types of colleges you may want to focus on:
(1) Test-optional LACs that have a good reputation for teaching quality but are not trying to get ranked (or to defend their rank) in the list of top-20 or top-30 LACs. Macalester is almost there, but is not test-optional, and is probably a smidge or two too snooty. Some other suggestions: Emerson (Boston), Trinity (Hartford, but it may be a little too much like Macalester), Sarah Lawrence (just outside NYC), Rhodes (Memphis), Goucher (Baltimore suburbs), St. John’s (Annapolis or Santa Fe), Occidental (LA), Lake Forest (Chicago suburbs), Lewis & Clark (Portland OR). Lawrence and Beloit are nice, too, but wouldn’t qualify as “urban or semi-urban” in most people’s books.
(2) Larger, urban Catholic universities – Fordham, Loyola LA, Loyola Chicago, Loyola Maryland, DePaul, Marquette, Xavier, Duquesne, Providence, St. Joe’s, Canisius, St. Louis, Louisville . . . .
(3A) Public urban non-flagship universities – Buffalo State, SUNY Albany, UMass-Boston, IUPUI, Michigan State, Wayne State, Cincinnati, UMBC, UIC, Arizona State, and lots, lots more.
(3B) Public urban flagships that are not as selective as some others – University of Vermont, University of Kentucky, Nebraska, UNLV . . . and how about Rutgers, which doesn’t seem out of the question. Or even Ohio State.
(3C) Think about Canadian public universities, some of which are excellent, in great cities, very large, and much less selective than US universities of equivalent quality: University of Toronto, McGill University, University of British Columbia.