[The North One]

If I had a gun to my head then I'd probably say St. Louis's surviving wedge would be the best combination of traditionally urban+functional.

Minneapolis is the most functional but isn't really urban at all in a traditional sense, it's like saying Houston is urban, it means nothing to an urbanist. And that awful skyway system knocks off a lot of points for their downtown.

Cincinnati's downtown+OTR area is small and surround by spaghetti junctions and parking garages behind the main corridors, it's not very functional for live+work even though it has the best urban "look" at the street level facade.

Metro Detroit probably has the most urban nodes of all of them but they're not well connected right now, give it another 10 years when regional transit gets figured out.

Pittsburgh seems to be in the same position as Cincy and it's very disconnected as well.

This is a pretty generalized surface analysis.