My kid just graduated from Midd. There are no fraternities and sororities anymore, and have been doing better regarding diversity, including economic. They have three Posse cohorts every year, and have also participating in Questbridge. Less than a decade ago, it was 78% non-Hispanic White, now down to 64% and still dropping. Not yet at the level of Swarthmore or Wellesley, and may not get there, but that is their trajectory.
My kid just graduated from Midd this spring, and she is LGBTQ and deals with ADHD. Midd is very LGBTQ friendly, and she has had really good support with her ADHD. Academics there are intense, especially for STEM majors - she majored in Neuroscience with more of a STEM tilt. Her friend circles were very diverse, and she also attended as a Posse Scholar, so she had friend groups that were very diverse. She was also part of a hiphop dance group for her 4 years.
For her, outdoors activities is a very large part of the “experience”. My kid spent a lot of time outdoors, either hiking or running, or just walking to the Knoll at night. She really only started doing this after she got to Middlebury. She wasn’t that much of an outdoorsy person until just before college. It also helps her manage her ADHD.
I recommend that you visit Midd. See if it meets your criteria.
I would like to comment that I like how you are looking at the college search process. I like that you are looking at college from the point of view of “are these colleges good for me?”, rather than “am I good enough for these colleges which I perceive as being prestigious”.
That is a very healthy and smart way to go about college search and applications!
Good Luck!
PS. I think that you will do very well in any of the colleges to which you are accepted.