As a San Franciscan not interested following everyone else moving away to places like Portland, Seattle, Austin, etc.; Pittsburgh has been on my list of candidates for several years now - even before Big Tech became interested. I am doing alright here in SF; but I would like to be closer to family back East.
High on my list of requirements is affordability, access to the arts & culture, some walkability, House/techno scene, nature, having a transit system, good healthcare, architecture, proximity to other cities within a day's drive, and having a diversified economy that is not dependent upon one industry. Pittsburgh easily checks the boxes.
Good to see new opportunities in cities that could really use them. My concern is the Big Tech investment wave could turn Pittsburgh into a miniature SF Bay Area - unaffordable playground for the wealthy at the expense of everyone else. At least there is no Prop 13.