If urban environments start seriously breaking down due to a food supply chain problem, rural areas won’t be safe from desperate people.
Anyway, both approaches have their pros and cons, but as someone who has a fairly severe back problem and not much inclination to try to live off the grid, I’d rather be in an urban area.
That's why you need to buy yourself a private, remote island, or at least a farm on a remote island. Also, if you don't live on it alone (regardless of ownership), it may not import more food than it exports, otherwise the other inhabitants will want to get your food.
Of course this is hard to find such an island as there aren't many such places and unless you're very rich it'll be beyond your budget anyways.
Also want to stress again that it won't be enough to just have an island, it has to be remote as well otherwise people just swim over. The number of boats is limited usually so likely few people will get to you.
I mean, there's a decent supply of islands (many with houses) that go for barely more than a Bay Area single-family home.
Something more remote is even cheaper, because there's a ton of supply of islands that are only accessible by float plane, and not much demand.
At least for America, most city folk don't seem to understand just how armed their rural counterparts are. They'd be pretty darn safe.
Mass hysteria + lots of guns = not a place I'd like to be.