I don't have any experience with any of those memberships, but do travel extensively within Thousand Trails. I'd imagine the experiences are similar.
Generally with TT, you're going to get an RV-park experience. The sites are usually pretty level and almost always have water and electric hookups. Many will have sewer, also. There usually isn't a whole lot of privacy between sites. I haven't been to too many where I really felt cramped (like I have at some resort destination-type places).
Finally, they're usually feature rich on amenities and activities - one or two pools, hot tub, minigolf, sports courts, etc.
Obviously, it's not for everyone. For the kind of traveling I do with our camper- it works well for us.