If a midwestern school with good financial aid is the goal, consider St. Olaf. It isn’t test optional but it meets 99% of demonstrated financial need, and admits 80% of ED applicants. And it is excellent for sciences, econ, and pre-med.
Re: test-FLEXIBLE schools as mentioned above, NYU is probably not your kind of environment, but U of Rochester could be an excellent choice as a reach/low-reach in this category; they will also consider AP scores instead of SAT/ACT if that casts you in a more favorable light. And they have a public health major and terrific premed opportunities.
Both of the above schools are known for music as well, if that’s something you hope to continue as an extracurricular.
As far as I’m aware, the full list of schools that are test-optional and meet full need is:
UChicago (IL)
Bowdoin College (ME)
Smith College (MA)
Wesleyan University (CT)
Bates College (ME)
Bryn Mawr (PA)
College of the Holy Cross (MA)
Occidental College (CA)
Pitzer College (CA)
Mount Holyoke College (MA)
Skidmore College (NY)
Trinity College (CT)
Union College (NY)
Dickinson College (PA)
Franklin and Marshall College (PA)
Connecticut College (CT)
Wake Forest University (NC)
IMHO it would be unwise to target the very most competitive schools on this list (i.e. UChicago). Yes, they’re test-flexible, but they have a single-digit admit rate and are unlikely to admit an unhooked applicant who doesn’t submit test scores unless that applicant has a super-high GPA (their median GPA is 4.48) and/or national-level EC achievements. But there are definitely realistic targets listed here.
In central PA (the most midwest-adjacent region represented here), Franklin & Marshall could be a great target for you. They have a public health major in addition to strong sciences and econ. (And your GPA is above average there, which is where you want to be when applying test-optional, and also bodes well for being able to get a med-school-worthy GPA once there.) They have very strong premed advising, including several different formal shadowing, mentoring, and research program.
Also in that area is Dickinson, which does not have public health but does offer a 4+1 or 4+2 BA/BS-to-MPH program with Columbia which waives the GRE. (You would need to inquire, however, about the cost of the MPH portion and what financial assistance would be available for that portion.)
If you’re female, Smith and Mt. Holoyke could both be great options, with strong sciences/econ/premed. Neither has its own public health program, but both allow you to take classes (through the 5-college consortium) at UMass Amherst which has a robust undergrad public health program. Also Bryn Mawr in PA, which offers a Health Studies minor within which some classes are public health themed, and also has a 4+1 agreement with Boston University. (Same financial caveat as the Columbia program above.)
At these schools where you are guaranteed full-need-met aid, applying early decision can be a great option you have a clear favorite and have run the Net Price Calculator to verify that it will be affordable. Franklin and Marshall, for example, has an ED acceptance rate that is almost double their overall admit rate. (62% vs. 34%)
There are many more test-optional schools on the Fairtest list that could potentially meet your full need with a combination of need-based aid and merit. (The midwest colleges mentioned immediately above - Lawrence, Knox, Earlham, K-College - all fall into this category… also Denison, Allegheny… and another women’s college, if that’s relevant to you, which has a top-notch undergrad public health program is Agnes Scott in Atlanta, where the CDC is based - they have cross-registration with Emory University and developed the public health major in collaboration with Emory.)
Hope that helps!