I think a lot of 'secondary' markets could take a hit. These are places that the main appeal is their current relative affordability or proximity to a more-desirable area. I think buyers that are priced out of 'desirable' areas today are effectively settling for these secondary areas, which is raising those prices. I feel like those will be the first areas to take a hit. How big that hit will be, I certainly can't say. It could be as little as a reduced rate of property appreciation, or it could be as large as a 20% hit.
Friends in the DC region aren't worried as this has been an ongoing trend for quite a long time (they have enough equity that a dip won't matter much). Friends in Southern California would probably say the same thing. But in Phoenix, I already hear some questions as to whether this will come tumbling down in a year or two.
Myself, bought a place (not a city and not quite the 'burbs) last year and I'm still curious about my local market so I still constantly check the real estate sites/apps just to see how things are moving in my area. Would suspect I'm not alone in doing this.
Outside of finance and government there isn't a large sector in most cities. Most businesses are in cheaper, suburban office parks. So beyond the social and cultural aspects there aren't that many advantages to city living, IMO.