I'm only in my early 20's but have been a lifelong Cincinnati, Ohio resident.
I wouldn't recommend anywhere that isnt Cleveland, Columbus, or Cincinnati. Places like Dayton (though has a good skate scene), Toledo and Akron are true rust belt shitholes (excluding Dayton, which is moreso just boring)
Columbus probably has the most thriving scene but it really is focused around the OSU campus. The rest of the city, while it has spots, is kinda drab, flat and uninteresting. There is a super sick DIY spot that is just a covered parking lot for a warehouse. Totally free to skate it at your leisure and people bring boxes, rails, and anything else worth skating. Super fun vibe.
Cleveland is dope and I love skating there, weather is a little harsher compared to the other two but it really is a fun city. It is probably the best city in Ohio when it comes to infrastructure and living quality, but that is just my subjective take and not based on any concrete statistics.
Though I hope to move after college, I really do love Cincinnati. It has its shitty aspects, but it really is a charming city with a lot of quirks. If you've ever been to Pittsburgh (really should, best midwest city imo) its just a slightly smaller, shittier version. Cincinnati spots are killer and have a handful of decent to great shops all within an hour-ish radius of the city.
I would hesitate to justify moving to any of them for skate spots. While having a wealth of them, most people I know just frequent their local ledge spot or manny pad as opposed to the actual notable spots in the city.
If you have anymore questions, I'd love to answer them! Mind you, I havent lived in all three of those options, but have spent enough time in each to give some decent input.