I’ll challenge this assessment because I assume by good school you mean top ranked.
But if you’re in engineering and you succeed, you were very capable. 40-60%, depending on the study, of engineering majors don’t finish.
My son and I don’t recommend his school for you - but he chose Alabama over Purdue with merit. So not just Purdue but with the rare scholarship. While I thought that was nuts for a no name engineering, he had two summer internships (first year roomed with Ga Tech kids from his internship), 5 job offers this Fall and is making similar or more money to high ranked school salaries for last year - I don’t know about these schools will fare this year.
. Btw - tons of kids did the same at his school - chose over more prestigious and I’m sure that happens at ASU, SJSU, Wisconsin l, Arizona, Colorado and more. They go likely for merit or location but he did so he could have his own room which wasn’t possible to his knowledge at Purdue.
The point is - if a school fits, don’t dismiss because you don’t consider it good. So schools like Reno and Utah work (in addition to others like CU and Mines) and at all these kinds of schools you’ll find kids like your son, kids that got into higher ranked schools but chose theirs for a reason - in your case a city or access to a city and easy access home .
If your son is serious about the non stop flight and city living , folks listed great targets and likelies such as SMU, Denver, Pitt and others above. UMN may be another vs Wisconsin (I couldn’t find Madison non stops).
in your case, if these are true desires there’sno reason to trade off. You have to be somewhere four years.
You should enjoy the time. If the student is a go getter they’re going to be fine !!
Edit - saw co op. Drexel, Cincinnati are others to look at but I think most schools offer co op. It was pushed heavily at my son and his friends schools and there were some from various at his internship. He wasn’t interested but the opprtunities are likely at most. Not sure how readily study abroad is for engineering but worst case a maymester or summer could be possible.
BU/NYU/GW - all Uber urban. So he has to want the city as a campus.
As for Vandy and WUSTL - I would challenge that they are not strong in STEM. But they are similarly reaches. ED, if you plan, could help at all.