Hermann is a lovely little town which is kept up much better than most small towns, due in no small fact to the steady tourism industry. But that industry gives the locals more quality options for dining and entertainment than residents in many places with more people. Or if you just want the greasy spoon type of meal, that is also an option.
I would say the schools are above average. The high school is less than 10 years old and is a great facility. There is also a private catholic grade school in town that I believe is K-8.
I would venture to say the town is mostly Catholic, but several other denominations are also represented.
People that live in St. Louis, KC, Jeff City, etc. own a decent amount of 2nd homes in the area, so the population seems to ebb and flow throughout a week. This is only magnified by the tourists also coming on the weekends. Expect a bit more traffic these days.
There is a real sense of some local pride. Most people who live there have grown up there, and this has been true for generations. Change is sometimes treated with skepticism, but as long as you don't move in and show that you want to disrupt the hierarchy you will be welcomed.
It is a small town though, so be advised that like any other place there's always some sort of local gossip going around. If you tell someone something, expect the entire town to find out. Depending on who you tell, perhaps within a few hours. So if you have something that you don't care to share with any average stranger, it's probably best you keep it to yourself!
If you have anything specific you'd like to know, I'm sure I could help answer it for you.