Dsilk,
Adam Clayman has it right, you want to join a club where you look forward to repeat play of the golf course.
If you select a quality course you'll enjoy it more, appreciate it more and you'll try to play it more often.
I also like quality courses with good practice facilities as I like to practice
As to fly times, it's about the same, 3 hours, no matter where you fly to in South Florida.
As to Charleston, SC, you'll freeze your ass off in the winter.
You need to go much further south.
And, you're better off staying in the same time zone.
If you're coming from Boston, South Florida is only 3 hours away, allowing for quick, extended weekends of golf.
Fly out Wednesday or Thursday night and fly back home Sunday afternoon. And, there are plenty of non-stop flights from Boston to cities in South Florida, East and West Coast.
Flying to the West Coast takes all day, not the location you want when you want to play golf for the weekend
Florida clubs are clamoring for members, so now is the optimal time to join.
Just make sure you join a club that's going to be there next year.