How to find a small town to relocate for remote work?

I’m asking here because I hear so much about NYC/SF tech workers being set loose by remote work and leaving. I’ve experienced this with colleagues relocating to SC, Lancaster PA, small towns in Maryland… etc.

Any ideas on whether this mid-sized town dream exists, ideas for cities, and/or how we’d go about finding it?