UBI would have a similar effect - maybe you still want to have a job, but you can choose to accept a somewhat lower paying job to live somewhere nice. It would also put less pressure on places like San Francisco.
Being less dependent on jobs is a good thing. We should allow this migration to happen naturally, rather than subsidizing people to stay where they are.
That isn't a problem. You get a concentration of people collecting a basic income who move into a low cost area, then they have money to buy housing and food and so on so there are jobs needed to construct housing and sell food, so then some of them get those jobs. Then they have even more money which leads to even more jobs etc. and soon enough the low cost area isn't so low cost, but that isn't a problem anymore because now they have jobs.
So now you force these poor people out of homes that they used to be able to afford into even poorer areas with worse job security. This is assuming that they're even able to acquire new jobs. And it would only get worse with automation.
A basic income that doesn't scale based off of CoL is one that's bound to fail in the face of automation.
A UBI causes the cost of living to rise in the short run. If you readjust the UBI the cost of living will rise again and again.
Cities like San Francisco will become more attractive because they not only have more jobs they also pay you more UBI. The more people move in, the higher the cost of living if housing supply is constrained. Readjusting the UBI then makes the city even more attractive. At the same time small cities become less attractive because not only are people moving into the city but their UBI is shrinking too.
A basic income would allow you to move to some town in Oregon or Colorado without having to worry about starving to death until you can find a job as a bouncer or the like. Once you do the presence of people like you creates some other jobs for plumbers and carpenters etc. The idea that this is going to turn every Podunk town in America into San Francisco or New York City and leave the poor with nowhere to live is clearly untrue.
A CoL adjustment for San Francisco isn't the problem, but rather the fact that San Francisco costs so much to begin with.