Maybe I can add a little to this conversation - not about costs of living, but about expectations and "the big move" - here goes:
Retirement - that is a massive lifestyle change. It requires major adjustments. Having an extra 10 hours a day to do "whatever" is more challenging than one might think.
Moving house - this is considered a 100% stress factor even if you just move a block away.
Moving to another town - add stress
Moving to another country - add even more potential mistakes, confusions, adjustments.
Add the four items above together and you get a full-blown life changing transition. No doubt most people have expectations about the outcome of almost any/every venture on which they embark. Usually some of what we expect happens and some does not. The more familiar we are with the venture the more often the results match our expectations. The more bold and different the adventure, the more likely you'll find things turning out differently than you expected. If you have an open mind you might find that the unexpected is really wonderful.
What I'm slowly getting to here is that you have to give things a try to find out how they are going to work out. Being prepared is good, but being rigid is a path to the nearest exit. Be patient and flexible and assume you don't have a clue about anything.
Lots of people flunk retirement. It has little or nothing to do with where they retire. They just miss work a lot more than they expected to.
Lots of people make successful moves to the wildest places. Probably the easiest moves are when you move for work - having a project, job or task gives you a sense of where you fit in, and gives you a context in which friendships are easily made.
I see so many folks get excited about QRP - but frankly I think that working here is half the fun. I would not "retire". My general recommendation is that if you are retiring "up there", don't box yourself into being retired here. Take a year of being here on tourist visas (you won't be able to work, but you will have tons to do to get settled), and then get permanent residency. You will have all kinds of possibilities that way and a perhaps a whole lot more fun.
When it comes to getting settled socially, maybe think of your retirement and move to the tropics a little like your grand-kids. Nobody is as interested in your grand-kids as you are. It's ok - that is just how it is. Enjoy the grandkids, enjoy your adventure in retirement in the tropics! Just don't expect that everybody you meet will be wanting to hear you talk about shipping containers of furniture or the cost of sour cream.
You may have to take the initiative in meeting people and building relationships. Invite people out to dinner or over to your house ..... they will come.
Take it slow and easy. Bring a good book and don't get too drunk. The rest will fall into place.