Welcome back Pete! Missed ya!
Sorry to hear that you will have to actually have the shoulder surgery. Sounds like there were definitely folks/experiences that you could plug into this thread! I can see why you would want to move to MH. Less hook-up worries while recovering? I see your love for traveling. Don't abandon it completely.
I can say that most of our camping is in "membership" reciprocal cg's. There are rules in place that can evict the kind of ignorant, histrionic/asinine, partying, etc that you may unfortunately see in state parks or public campgrounds; they can lose rights/memberships over rule infractions. Rules suck, but so far we appreciate them. Fortunately, our major complaints so far are other members who don't poopy-police their dogs. We haven't experienced the drunk parties, lights after 9pm, or kids on the loose after curfue. BUT... we still will get those folks that stroll through our little piece of real estate as a short cut to the showers or lake!
(one almost scratched the side of our truck with a pole he was carrying!).
Hope you are able to recover from surgery, get the MH, get back to camping, and have the unfortunate ability to add to this thread