IF you like the OR coast area and go often it might work for you. Back when we were C2C members ( gave it up when health made us give up the RV) We stayed at Neskowin several times and enjoyed it. Nothing fancy but good access to the central coast areas. Buy in - only if you need a frequent place to stay on the central coast.
We were frequent users of our C2C membership and our home park (Colorado) but if you are not frequent RVers then I can't recommend membership in either a "home" park or the C@C affiliation that they may try to sell you on.