I've been to Cincinnati..I wouldn't say it's anything special in person. It's right there with Cleveland or the Charlotte example you posted. Most American downtowns are a little underwhelming in my opinion. The only ones that really blow me away are Chicago and New York (but man are they good).
Minneapolis has some really nice vantage points. That whole metro kind of reminds of what Calgary and Edmonton would look like if they were combined into one.
I also think the Seattle skyline is very nice...it has some really nice backdrops too from certain viewpoints, and I think it looks better in person.
Philly has a nice view coming in from the Jersey side on the Ben Franklin bridge.
I always found LA's skyline and downtown in general to be pretty disappointing. Boston is ok I guess. It's a nice setting, but I found it a little bland.