We've been to a fair few dog friendly cps, and honestly, we haven't had a drama. Those with dogs, from our observations, did the right thing by cleaning up after them, they weren't nuisance barkers, they were always on lead and they weren't left alone. In many cases, you wouldn't know the dog was there. I'm well aware this may not always be the case, but this has been our experience to date.
We try to be good examples of dog owners, precisely because we don't want our options diminished. There are FAR more cps that don't allow pets than do, so I think there is still plenty of choice for those that would prefer to be dogless.
I know our dogs are barkers at home, but on the road, its not their turf, and they rarely bark. It's obnoxious people who don't know how loud they are, or do but just don't give a rats, that are far worse IMO. But each to their own.