Nick,
I grew up about 1.5 hours east of Cincinnati and still go back on occasion. I usually fly into Cincinnati and the airport is located just across the river in Hebron. If your job is in Hebron you don't necessarily have to live there. There are lots of suburbs around Cincinnati that are really nice and the real estate is probably priced about the same as where you are now.
It's hot as Hell and muggy in the summer and cold in the winter, but they usually don't get large amounts of snow like people up around the great lakes. Downtown Cincy is probably a lot safer than most parts of Detroit, but they do have crime like any other city. As far as schools are concerned, Ohio and Kentucky have some of the best public schools in the country. Had I not been in a family business in California for the last 30 years I would have stayed in Ohio and raised my kids there. I have many fond memories of my childhood and still have family there. Things haven't changed much since I've been gone and if I had a good job opportunity in that part of the country I'd take it. For what I pay to live on the south end of middle class in California, I could live like a king in Ohio. Dayton is about an hour north of Hebron and there are tons of burbs in between where there are great communities, schools and good old southern Ohio hospitality.
Good luck!