The Cleveland-Pittsburgh difference is interesting.
The main differences seem to be:
Pittsburgh is a much whiter metro than Cleveland
Pittsburgh is Appalachian, Cleveland is Great Lakes/Yankee
Cleveland probably has a less working class white population in the metro, has some "liberal elite" or Main Line-esque type suburbs like Shaker Heights and Pepper Pike that I don't think Pittsburgh really has the equivalent of.
I don't think that "latte liberals" are totally inexistent in the Pittsburgh metro. I think the main difference is TEH COAL... there is nothing like Westmoreland or Washington counties (which are not exactly tiny counties) near Cleveland.