Hmmm...
I think a lot of the people who think Ohio is so bad either have lived here forever and are sick of it, or came here expecting it to be something it wasn't and were so disappointed that can't get over it.
Is OHIO (any part of it) the same as LA?? Of course not!! Its not NY city either!! But you seem smart enough to realize that.
It is the midwest. That means some liberals (yep, some of us here do believe in gay marriage, a woman's right to choose, and that the current war is stupid) some conservatives (some of us home school, think women belong behind their man, think "gay" in any form is a horrible sin, and that a woman who gets rid of an unborn child is damned, and that current war isn't enough!), some rich, some poor...
but in general more in the "middle". its not bible belt like the deep South, but its not going to be San Fransico either. I just moved (am in the process of relocating) from the Detroit 'burbs to Cincinnati. Its a little conservative (for my tastes) and definitely the city thinks its SOUTHERN... but there is stuff to do, the people are friendly, the economy down here seems pretty good (compared to Detroit/Toledo corridor) and real estate is comparatively cheap.
Good luck, keep your head on your shoulders.. If you get time, come out and visit for a while.
There are museums, symphonies, clubs, restaurants, zoos, river boats, and examples of culture (German, Hispanic, Appalaichian) all over... you just have to not be "bored to death" and willing to look..
good luck!