Highly depends on the team. I've seen teams where most members are remote but most teams I've been on shun working-from-home regularly.

That and most companies pay based off "cost of living" and you cannot expect Bay Area pay outside of the Bay Area. Asking for work-anywhere-in-the-world remote work basically feels like shooting yourself in the foot if you value compensation.