Hotel
Flight
Hermann, MO is an hour away from both STL and CRU airports. STL will most likely have more flight options.
Train
If you fly in to STL and do not want to rent a car, an option is the Amtrak. You can take an Uber from the airport to the Kirkwood Amtrak Station and take a train to Hermann. The trains typically run twice daily.