Thirded. It also depends quite a bit on the pet itself. Most dogs are very cute and well behaved, but some are quite loud and then there are some people with completely spoiled and possibly aggressive dogs, who are then put under stress in an enclosed space with a lot of other animals (prey and rivals alike). Combined with an owner who is unable or unwilling to control them, this is a recipe for disaster. Sure, there are not too many of those, but it only takes one to ruin a lot of days at once.
And the people who own that last kind of pet are the least likely to believe anyone sane could ever find their pet annoying.
I've never seen a hotel with a "pet friendly" section, usually hotels that allow pets allow them pretty much anywhere.
I once made the mistake of staying in a 'pet friendly' section of a hotel. The smell alone was enough to make me check for that next time.