Providence member here. Would highly recommend, although it's a haul for me to get down there (I live close to town). Sounds like you'll likely be in that general area. You also get (relatively) unlimited access to 11 other great clubs including Sedgefield, Old North State, etc. Course at Providence went through a $3 million renovation in 2018 that greatly improved the layout and especially the greens (used to be garbage). They were rolling at a 12.3 the other day.
Not fan of ClubCorp clubs (unless you travel a ton for work, perhaps), nor of the course at Piper Glen. Like the course at Firethorne a bit better. Raintree is really nice that you have two courses to choose from, although the membership is massive and some of the amenities a bit dated. Don't care for the North course too much, but really like the South.
Unless you're looking for one of the new member "deals" the ClubCorp clubs sometimes offer, I'd go with Raintree of the three you mentioned. But check out Providence. Not really sure on how the food compares, but the pool and tennis facilities (recent $$$ upgrades there as well) are significantly nicer at PCC than the other three IMHO. Cedarwood is another solid option for golf, less so for the other amenities (don't think they have tennis and pool is small/older).