As we would all likely agree, pets are a reflection of their owners in many ways.
I don't mind pets in campgrounds at all, as long as they are not a nuisance. But that is just an extension of the owner's, most often. People whom are respectful of others will be that way with their pets. Folks that are ignorant/arrogant of other peoples needs and privacy are often rude and cause issues, and so will their pets. And it's not just pets; their kids are the same way.
I've seen many which are a pure treat and wonderful; they are playful but don't cause a ruckus, they don't make much noise, and they stay on their site with their owners or in the designated play areas. That's because their owner's have properly trained them. Respect begets respect. Oh - and their dogs are well behaved also! LOL.