Sure, the absolute top paying jobs still require you to live and work in a few, select cities. However, there are many companies that are competing with SF/NYC companies regardless of talent location.
There are a couple of good tools for searching.
I've had an extremely good response rate from the HN jobs. It seems to have a lot more motivated listings.
Weworkremotely.com is my go to for remote specific jobs. There are dozens of spin-offs, but they essentially scrape the same underlying data.
Weworkremotely seems to have less desirable/less motivated roles, but I have had some good conversations. You will notice a handful of companies that seem to be endlessly posting on those sites.
Then the cutting edge work seems to be rather myopically focused on advertising, surveillance, yuppie culture products or developer tools.
Plenty of arguments for talent to look away from the Bay Area.
I think the early 2000s burned a lot of companies for trying to cheap out on dev costs by offshoring - offshoring is a valid choice in some situations and will probably become more and more competitive as time goes on... but there still is quite a lot of value in hiring out of the four year uni grad pool.
I imagine there is a correlation between novel/interesting ideas that generate new revenue and being immersed in an environment of peers that you collaborate/chat with.
However remotely I am basically never off. A common thing that comes up with remote work is you have a hard time just turning off, but I don't mind as I'm not mentally exhausted by interruptions and can actually enjoy the work I'm doing.
But I'm sure its a person to person thing, type of environment, industry, etc.