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.
The Pittsburgh metro is an incredibly diverse metro at least on a class scale that has been incredibly stable. Until 2020 most Democrats this century have only gone a 15% margin out of Alleghany county due to counter trends.
https://rrhelections.com/index.php/2020/04/21/pennsylvanias-17th-congressional-district-a-sociocultural-and-political-analysis/This is one of the best round ups on the different groups inside the metro besides Pittsburgh itself. A lot of populist small town areas but also a lot of super rich areas. And these areas are merely a few miles apart .