My goal is to create generational wealth for my family and to eventually have the financial freedom to say "yes" to travel adventures as a family. 

MTR attracts a lot of traveling medical professionals and WFH individuals who need a quiet space during the day, which may not be compatible with families living in the attached LTR.

Since we're In a college town, a majority of our travel demand revolves around the Texas A&M University and the university's events.

Quote from @Mike Grudzien: Two thoughts:1) stay in your STR for a day or two and you'll discover things it needs or that would be nice to add2) use several touch-points to communicate with Travelers/Guests.

This can be especially appealing for those who enjoy traveling or seeking occasional getaways.

Since you plan to travel often, focusing on systems and building a reliable team: agent, lender, property manager, and contractor. 

However, I am seeing more interest in MTR's and have a colleague that does well buying condos and renting out to traveling medical workers and foreign exchange students.  

It’s amazing to see how much the market has changed since then..and I remeber reading an article in Forbes that talked about how travelers often prefer unique stays with great locations.A friend of mine up in Lakewood had a client who tried an Airbnb in a condo overlooking Sloan’s Lake.

Lastly, check any shared doors or gaps and add door sweeps or weatherstripping to block sound from traveling between the units. 

As a resident (who travels a lot) I would say the Midwest does not have the attractions like palm trees & beaches (the great lakes are cold) or amazing mountain ranges, which often come with some disadvantages like high cost of living or hut/humid weather, stroms etc.