Sounds like you need to consider a house that is reasonable and comfortable. A patio villa is what we decided on and we live here full time. Cost of house upkeep it a lot less and we have more time for fun. We just got tired of the two house situation. We were spending too much traveling back and forth and worrying about other place when here. Plus cost of keeping up two places. We have considerable more money to enjoy with one house especially since we for patio villa.
Colony has big master bedroom and guest room has enough room for queen bed and crib or cot for grand child we also have pullout sofa for grand kids. Dining room big enough for tabl with six chairs and nook has for more chairs. Living area big enough for seating six to eight. You get the idea. Place for car and golf cart. Here is link to one like ours. Cost of upkeep is a lot less too.
1458 Olympia St, The Villages, FL 32163 | MLS #G5067386 | Zillow
Next, you need to think of all your costs.
You have a place in MA. How much are you spending on this place? Taxes, insurance, maintenance, utilities, etc. Doyou have a car there too with all the upkeep costs for it? What do you do there for social and fun?
If you become a Florida resident, you will have no taxes on your income, your property taxes will be lower with a cap on any increase each year. If you live here full time then you could use the money from the sale of MA place to pay cash and probably have money left over to live on.
We have 56+ golf courses, 180 clubs, pickle ball, putt put, Numerous pools, biking, and more to keep you busy and meet friends. There are also a lot of volunteer opportunities. Grandpa camps for kids to have things to do when visit.
Take quality of live in consideration along with finances.
Good luck.