Missouri S&T sounds like the best fit for you, in terms of affordability, environment/vibe, geography, and strong reputation. If you can be accepted as a freshman, I doubt you’ll find another option that will beat this one.
If applying as a freshman doesn’t work out, they have transfer agreements with both community colleges and four-year schools: Transfer Guides – Future Students | Missouri S&T I’d go down that list and see what schools on it look like viable options for you. On this list, there are both community colleges (which could be more affordable) and four-year schools (including some you’re already considering, like Maryville and Truman State), which would also give you the option to not transfer and complete your degree at the school where you started. But whichever you prefer, I think this list is a very good place to start.
It’s hard for me to see your OOS/private options working out. Even South Dakota Mines, which is the ultimate bargain of small, well-regarded STEM schools, would be out of budget. (Unfortunately, MO is not part of their SD Advantage reciprocity agreement.) Luckily, you’re not one of the many students who feel strongly about leaving their home state for college. So I’d focus on the pathways available in the MO public system (or the commutable Illinois school that was mentioned). If you get into S&T on the first pass (which is certainly possible, just not completely assured), and the $ works, go for it and don’t look back. If not, you’ll still have good options from that list.