Thanks for the posts and advice so far.
Some other, possibly relevant info: My SO is really close with family, and it was extremely hard for them to be 12+ hours away. We're now about 45 minutes away (we actually settled in a nearby suburb that I felt best about, given restrictions of being maybe 45 minutes to an hour away from family), and we're seeing family 5-6 times per month, holidays not included. Sometimes their family volunteers to come over and help paint, or take us to lunch or w/e. I absolutely adore my nieces and get a lot of joy from watching them (though I'd prefer to have my own kids) and the family are all really there for each other. All else equal, we would have moved within 5-10 minutes of them if I didn't find the downriver area to be so incredibly depressing. And, unfortunately, none of them are likely to move. A few are engineers in the automotive industry, and there's also the sense of "well I'm not moving away from family", so nobody is going to move away first.
The town that we moved into is a nearby suburb of Detroit, maybe 30 minutes from downtown. It's relatively safe, has great schools, is relatively prosperous, and pretty sleepy. It's walkable - during summer we're next to a great park, and 5-10 minutes by foot from restaurants and other cultural amenities. I like this tiny town quite a bit, but it's only 2 x 3 miles, we're in the middle of winter, during a pandemic. On a day to day basis, I'm realistically seeing about 2 minutes of it on my way in and out. If I could find a job in town that I could walk to, doing something I enjoy and could make a reasonable living doing, I suspect I'd be content. It isn't gorgeous like Vermont (which I'm coming to realize was a huge quality of life factor for me), but it's a pleasant patch in the middle of an otherwise (for me) tough and depressing region. I also wonder if I might not just have a lot of hedonic adaptation. Surely if others can be happy in the area, so can I? The problem being that I've known better.
You mentioned project management in your prior job, which makes me wonder what other skills you might have that are not in your vision field right now in terms of employment.
Maybe list out all the professional skills you have, experience you have, and hobbies you enjoy. See if there's something on that list that sparks interest and you can start looking for matches with that. I have friends who've had a lot of luck with LinkdIn profiles too.
If you land a remote job and don't want to work from home, you could look into co-working spaces near you. Part of the cost of the job.
I've been doing some of this, but thank you for spelling it out for me.
One job I actually have gotten a call back for (but haven't had an interview yet) is vegetation management for the local utilities. I was surprised to learn that it's something you need a degree for. The job largely seems to involve walking around and looking/identifying trees, and then talking with homeowners, city counsel, contractors and utility companies to remediate the issues. I have the impression I'd get the lion's share of my work in my town, and those immediately surrounding it, though I would be covering the whole metro when others in the company aren't available to make an appointment or cover something. The downside? I'm not yet certain what the career advancement opportunities are, that don't involve relocation (e.g. moving to regional office and going into management), and the starting pay is around half of what I'm making now. That's a tough pill to swallow, though perhaps an inevitable one if I want to change careers and work locally in an area with a tough job market and relatively low salaries.
I also have a reasonably strong resume in IT, but that too seems pretty competitive. I've put in a few dozen applications for positions which I believe I would have been highly overqualified for and would have had offers for, were they in Vermont, but every one so far I've either been turned down for, or heard nothing from.
I can probably think of a few other hobbies that might have practical application, but overall I get the impression that, compared with some of the more prosperous areas in the US, there just isn't the economy for some "frivolities" to make paying careers.
I haven't tried LinkedIn yet though. I'll give that a shot. Thanks!