Columbus is kind of known for not being known for anything.
I’ve lived here for a little over 15 years and various places in Ohio for every bit of my 40 years. There are things to like about it (low cost of living compared to the rest of the country, 4 seasons of weather) and things to not like about it (really, too many people for me – I’m from a rural area, and local and state government are not great). I like that it’s kind of a generic Midwestern town. Plenty of sports to watch if you like that kind of thing.
I think it’s underrated. People are moving here like crazy, so maybe they agree, but it’s causing rents to get out of control. I feel bad for those moving here. It’s a lot less affordable than when I came in 15 years ago.