As someone who works in tech, I am seeing firsthand the migration out of SF/NYC. Don't underestimate techs companies ability to quickly copy each other for the best talent.
The future I see for these tech companies/startups is a percentage of employees who are full time remote (20%), as well as more, smaller regional offices combined with HQ in a mega city. This means places like Austin, Denver, Dallas, LA/SD, will do well. Tech companies can take over an area like locusts, so don't underestimate the continued appreciation in these cities even though they are already pricey.
I don't think this will mean the demise of NY/SF like many predicted. I see continued, strong growth in these cities as young urban dwellers still want to live in these places the most, and don't have huge salaries/savings to care about the tax savings/QOL differences yet. I see a scenario where small, regional cities will see the strongest growth over the next decade, with the largest urban centers having strong but not as crazy growth as this past decade. Many tech companies will still have HQ in SF/NY, but with a clear career path and policy for "going remote" to other offices, creating a stable pipeline to the suburbs outside these regions as well as satellite offices in tertiary cities. Right now
As for finance/bank companies? Who knows. My guess is some may relocate to cheaper cities, but they aren't doing it to compete for talent, but to save costs/move to where the CEO wants to live, so the change will be slower if at all.