Personally, I have never thought it worth buying a second home anywhere. Unless you want to make some money with it or use it to hedge against inflation (bricks and mortar apparently never lose you money in the long term).
Instead of keeping a home permanently, I'd rather stay at some luxury hotel or rent a luxury gîte in a different place every year. Have someone do the maintenance, pool, garden, property. Enjoy myself there and pack up when the weather turns ropey and head off back to my own home.
Plus, you'd still be quids in😆