for immediate use, it actually would make more sense to buy an existing house on a lot (unless one was looking at FIRE 10-20 years out) as they are going for below cost to build at this point - you can get a solid house for 100K, and a canal house for 200K in Cape Coral, though, as above, there are many many risks to consider. The City Data forums are good places to hear all the whining about what is wrong with each area.
If I was in my 40s and still looking at a few years to retirement, it might make sense to buy this sort of lot and slowly put up an inexpensive cottage-type structure - mostly self built over winter vacations, as a second home - converting vacation time from hotel bills to an equity building exercise.
This would be something for a creative sort of person who does not have a corporate level of income, or a blue collar type, who is not offended at the sight of a harley.
I agree that it would be risky to put money into something in Florida if one were not going to actually use the property. Rental income or capital gains is iffy for the medium term.
One of the strengths of a lot in a quasi-rural township is the lower taxes and lack of HOA fees. Condos, these days, have the significant risk of the builder going under before completion, bundled amenites such as golf courses going under, fellow condo owners going under and leaving vacant units.
I am in one of the very few uncompleted condo developments that is actually moving new units (Stock Development - Paseo), and I will be a bit nervous until we get closer to 95% build out. Then I get to worry about possible condo association politics and mismanagment, as well as the risk of outright corruption and criminal activity once the association is turned over to the owners.