Unfortunately there are a few. They are mostly RV Resorts.
One I have in mind is Marina Village Camping Club
Marina Village Resorts | the best kept secret on Lake Livingston
They do not allow motorcycles at all!
I stayed at this resort once as a guest of my wife's uncle. A very nice gentleman - I think the club President - approached me more than once about becoming a memeber. It was a nice campground in a great location but - and I told him this - they have one rule they'd have to change if they want my membership. They'd have to allow me to bring my motorcycles.
To that he said, "... well, you can park them up at the gate, walk there then ride anywhere you want!" Really!
He went on to tell me that the rule exist because in the early days of the campground, when they were still in the middle of nowhere, many people would ride there dirt bikes through the campground. So they just banned them all. I told him that as a licensed motorcycle rider, on a street legal, insured motorcycle, I had a serious problem with their rule.
Needless to say... they didn't change their rule... and we're not members.