I think there is a big difference between buying a holiday home abroad versus relocating to another country. I have friends who have done both:
1. Holiday home abroad: this is hugely attractive for lots of us, head off when you want, leave your clothes there, no rent to pay. Ideal! Downsides are well described by Leper and others, local taxes, cost of services such as water, power, trash, community taxes, municipal taxes, security while you aren't there, tenants, neighbours, unscrupulous letting agents, not having a choice of holiday destinations, hiring/buying car for your visits etc.
2. Relocating; our friends who were in #1 above have taken the plunge and sold the holiday home to purchase a 3 bed villa with pool, gardening and pool service. They say they can live the lifestyle on €42k per year, including private health insurance. They have no intention of ever returning to Ireland to live but we shall see what happens if one of them passes. In that case, the equity in their villa will easily buy a small home in rural Ireland, where they are from. None of their kids/grandkids live in Ireland although that may change but it's as likely to be UK as Ireland. Incidentally, they live in an ex-pat bubble and make no effort to learn the language which may cause more isolation over time.
Other friends who have/had holiday homes have sold or are selling as the shine has worn off, kids don't join them on hols etc.
I love the idea of a house in France or Spain but I fear the reality would not meet the dream and I don't have the resources to mess it up and recover financially. It's difficult enough to maintain one house here etc.
Finally, Covid may end up altering the international travel dynamics indefinitely and there could be a knock on effect on property prices in ex-pat enclaves.
Lovely idea though!