I moved from AZ to Hartford area in 96 after college. In 03 DH and I followed a job opportunity to KC and in 07 decided to move back to the Hartford area. So we like it. No it's not the most exciting place for young singles and the childless, but for someone with young kids looking for your basic suburban life it's great. You get way more affordable housing than neighboring NYC and Boston, but you're smack dab in the middle and can do so many day trips or weekend trips. Boston, NYC, skiing or leaf peeping in Vermont, Nantucket/Marthas Vineyard/Cape Cod, beaches, Newport RI, Maine, etc.... All within a few hour drive.
As for towns, I lived in Windsor and Bloomfield before having kids, but wouldn't buy there now that I have to think about schools. We're now in Ellington after shopping for houses in many of the following towns. We love it here. Very rural, small town fell, but still plenty close to the shopping and ammenities of S Windsor and Manchester.
As for towns
Prestigious- Well thought of, sought after, EXPENSIVE, and sort of a snooty reputation: West Hartford, Avon, Glastonbury, Farmington, Avon, Simsbury. I would certainly be willing to live here, but if you're suffering from some sticker shock you probably won't find as much house as you want for your budget
Value Towns- Still well thought of, but not as prestigious, good schools, good family towns, more bang for your buck: South Windsor, Grandby, Suffield, Ellington, Canton, Hebron, Colchester, Tolland. With these you need to decide how much of a commute you are willing to do to save some money.
Make sure you know how income taxes and property taxes will stack up agains your Ohio situation too.