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.