@1984ad Have you run the EFC for Columbia? Would you be able to afford it? If so, why not keep it on the list? Good grades, top test scores, strong essays, and letters of recommendation are the foundation of a strong application. Most of those admitted have not cured cancer by age 17. As long as you do something productive with your free time, that’s all anybody can ask. As a sophomore, I suggest you find some activities that might interest you or maybe get a job and/or do some volunteer work.
The vast majority of qualified students won’t get in to Columbia. If your stats end up being competitive, for the price of the application fee, you can take your chances with everybody else. Keep your expectations low and maybe you’ll be pleasantly surprised.
I think you are showing great presence of mind to distinguish between schools that are unrealistic because of cost and those that are unlikely because of selectivity. As long as you end up having some true financial and admission safeties on your list, it wouldn’t hurt to try for an admissions reach or two, assuming the financials check out.
Temple University in Philadelphia has automatic money for high stats applicants. It’s not Manhattan but it’s within striking distance.
If you want to stay in NY state, you might consider running the calculators for Syracuse and U of Rochester. And of course, apply to a SUNY or two for backup. I don’t know much about the quality of other NYC options and how good they are for aid. Maybe look at CUNY or Fordham?