You may want to take a look at the Gulf of Mexico coast of the Yucatan Peninsula - relatively affordable compared to the Caribbean side and there are some small towns that have some expat population.

There are also many smaller cities on the Pacific coast - some have a lot of US'ers and Canandians during the winter. RVGringo will know a lot more about them than I do.