HI @Glen S.
I was born, raised, and still reside in the Clearwater area (just moved to Tarpon Springs). I own 4 rental properties all of which are in Clearwater. While I don't have any experience owning mobile homes, I'd be happy to discuss anything and everything about the area.
Mobiles are popular with seniors and snow birds in the area. I can't recall ever seeing a 55+ park in the area that isn't in great shape. Some of the family parks can be a little run down (good opportunity). This is just my opinion but I wouldn't think you'd have a great demand of people wanting to bring their own new mobile into a park, but I would think there's demand to buy a nice home that is already installed and ready to occupy.
I know that one of the parks off of Gulf to Bay is going to be torn down and they are planning on building a townhouse community (its right on the water). So that will displace about 100 residents in the very near future. Most of the homes in that park though I believe are rented (and rather old).
If there is anything I can help you with please let me know, I'd be happy to drive by and be your eyes / ears.