Lived there until a year and a half ago.
Oakley/Hyde Park is arguably the most desirable for young professionals. If you want to ball out, try and find a place up on Mt Adams, but wintertime is a b*tch cause of the hills. Over the Rhine (OTR) used to be super seedy but has gone through lots of gentrification. That's where the most popular brewery is (Rhinegeist). It's way safer than it used to be, but I still wouldn't leave any valuables in my car when I went. The Cincinnati Oktoberfest is a blast too.
You'll want to sh*t on Skyline chili, but go in to it with an open mind and you might like it.
As commented, summers aren't bad. They'll get humid occasionally and in the low 90's. Really great fall and spring time though. I loved fall in Ohio.
Winter can be tough. FWIW I spent a year in Cleveland before transferring to Cincinnati and the milder winter was seemingly a godsend.
It won't be super mild, but it won't be a brutal winter either. You'll get some snow and cold temps but overall the state of Ohio is great at clearing roads.
One thing to consider, if you want to avoid state income tax, live across the river in kentucky.