We just completed our 5th year of going to Florida with our 5th wheel. We've seen snowbirds in everything from a popup camper (not recommended) to very expensive Class A motorhomes. Finding your degree of comfort is important and it's helpful if you know what that might be before purchasing something so small that you're not comfortable staying in it for extended periods. If you prefer staying for short periods in many locations a small unit can be easier to get around in. For longer stays something that affords you comfort (a nice lounge chair or comfortable sofa) will be appreciated.
You can definitely have fun pulling and staying in a 24'-26' travel trailer. Again, it all depends upon what you consider fun. Some folks like to lounge around the pool or go to the beach. Others are into crafts, golfing, fishing, reading, socializing, walking their dogs, or sightseeing. There will be many days that you will want to stay in the park for activities or you might want to get out often. Unfortunately going out often generally causes you to spend more money, although there are many free activities you can take part in.
We now stay for 4 months in the same park. Originally we did more traveling around Florida checking out different parks and areas of the state. We stayed in some state parks as well as private parks. The daily costs in private parks will be reduced by staying for a month or longer. At first we did 3-4 days to a week in various parks getting to know them. By the 3rd year we've pretty much stayed put.
Your preference for a specific type of weather will dictate locations you will stay. Obviously Florida will be warmer than your home area. We're are from Michigan and while we like the warmer temps in FL we don't need 80 degrees plus very often. We've found that the Crystal River, FL (about 75 north of Tampa) area meets our climate needs just fine. Warm, but not too warm. Cool, but not too cool. I could take 75 degree days and 50 degree nights all year long, but that doesn't always happen. Still, we don't have to shovel any white stuff.
Our typical lifestyle during a week includes me golfing at least a couple of times. My wife likes aerobic type classes. We both power walk early in the day. We both like to read. I'm still picking up a wood carving hobby (just started this winter when introduced by a fellow camper in our park) and we enjoy sightseeing. I play horseshoes twice a week in the park and we attend a weekly campfire with friends we've met in the park, enjoying a few drinks and snacks to dishes to pass meals. Plus there is always plenty of social interaction with fellow campers, some new and some not so new to us. If you like to be stationary, not real active, you should be sure to bring nice outside lounge type chairs.
Comfort (I've mentioned this previously for a reason) is important and unless you're gone from your camper all the time you're going to want to make your home base a nice relaxing spot. A nice size RV to haul those comfy items is important. The smaller the unit the fewer things you can bring. The smaller the unit the closeness you will feel on cool and/or rainy days. Small units are somewhat difficult to cook in or watch TV in. I'm suggesting something 28'+, but again, it's your preference for what you want to bring and how you live your life.
Costs: The further south in FL, the more it costs (think $900+ per month up to $1,200 or more). The center of the state, even south, is relatively less expensive. We checked out Sebring and found monthly costs as low as $500/month to a few hundred more. It's a nice area too. We're north of Tampa a fair drive with no big beaches or traffic and prices are around $700+/month. Some places, for long stays, will also charge for electric. Our park does not, plus we have a nice cable selection. Definitely spend some time at RV Park Reviews.com researching different parks in areas you might like to visit. You will find daily-weekly-monthly rates and you can often see photos of parks and read about amenities offered.
And finally (sorry this is so long) in regard to whether it's worth it. Well....of course it is. I'd say that nearly 100% of the folks I interact with at our park love the lifestyle. Of course this doesn't take into account those people that try it and don't like it. I don't talk to those people because they are not snowbirding with the rest of us. Many in our park have done it longer than we have and we plan to see them again next winter. If you or your spouse are iffy about leaving your home friends and family you might not enjoy the winter away from them. But then again, there is always a phone to talk to them. They will envy you. That I can almost guarantee you.
2018 Chevy 2500HD Duramax - 2015 Cedar Creek Silverback 29RE
16K Huskey EZ Roller Hitch - EU2000i Honda Generator