What you propose is unfortunately just not realistic, it takes way more work and knowledge than you think to be self-sufficient and it’s almost certainly not possible without a rather sizable group of people helping each other out.
I would instead suggest finding a place to live where there’s a sense of community, where amenities and the workplace is within walking/biking distance and you have access to “quaintness” for lack of a better term. Basically the more it looks/feels like a medieval place the better, such places are viscerally enjoyable to be in. Doesn’t have to be rural at all.
A good shorthand indicator of places where you will most likely start enjoying life again is a lack of cars, it’s not necessary but it tends to imply these human-centric features.