I think that if I took any of my 3 with me on vaction--especially to Disney where there are lots of rowdy kids--they would hate me forever.
But I can see where a pet-friendly hotel would attract some people. Maybe those who 'smuggle' their pets in to the non-pet friendly hotels would be encouraged to stay there instead...