I grew up in rural Ohio (left because of the horrid economy of the 00s) and have spent over the last decade in Southern California and the California Central Coast.
I would never move back to Ohio, but that is for very personal reasons. I'd actually absolutely love to get out of California right now, but my wife is working her dream job for her dream company and cannot work remotely -- So, we are here for the long haul, it would seem.
Columbus is an amazing city with some of the very best health care in the world in the Ohio State Wexner Medical Center. Cincinnati wasn't far off, either, at least back in the 00s, and Cleveland, as well, but don't quote me on that. How it _works_, I couldn't really comment on. My experiences with health care in the area are almost 2 decades old at this point, but my father is a very sick man who has managed, miraculously, to keep trucking (on pacemakers for the last 13 years) in no small part because of the access he has to great health care living somewhat close to Columbus.
Columbus, OH is also very gay friendly. Are there bigots there? Yes, of course. There are also bigots in every neighborhood I've lived in, in California, in Atlanta, GA, in San Antonio, TX, etc...
There is a lot of culture in the area, as well, and it can be had for affordable prices. The Columbus Symphony Orchestra is great and tickets are, I believe, still easy to come by (financially). There are plays. There are museums. There's only 1 professional sports team in Columbus, so it is utterly dominated by The Ohio State University sports, but Cleveland and Cincinnati both have MLB, NFL, and the Cavs are obviously in Cleveland. Pittsburgh is a great city to visit, has major sports teams, great food, lots to do, interesting history, and is only a 3 hour drive. The Bourbon Trail is nearby (though I've heard mixed reviews from friends). There are Frank Lloyd Wright homes that can be toured (Fallingwater and Kentuck Knob both being about 4-5 hours from Columbus, close to Pittsburgh -- I've taken my wife to both in the 3 times that we visited the area). Cedar Point and Lake Erie are fun in the summer.
> can I still get bulgogi and ramen?
Some of the best Korean food I've ever had in my life was in the middle of Georgia, for what it's worth, and I now live in Irvine, CA and eat Korean at least once every week. It's very easy to discount the places in the middle of the United States without ever having been to them. And I'd encourage you to visit some of these places. I spent quite a bit of time in Nashville and Memphis and Raleigh and Savannah for work and loved my time in each of those cities. I have friends working in Nashville today and they're always droning on about how much they love it. I've been to Austin, TX, and it's a fun town, too, but I'll never live in Texas again by choice, but you may have a different experience.
There are a lot of great cities out there with a lot of opportunity, especially for raising a family, and people should stop making judgement calls on them based on things they see in the news (or, at least, do your own research).