@Wes369 As with many things, the irresponsible ruin things for the responsible. There seems to be a lot of entitlement around these days- people who try to "get away" with things, whether it's filming a porno without mentioning that intention, or claiming one's ill-trained pandemic puppy is a "service dog".
Short term rental hosts have so many people lie to them, that it just becomes easier to say "no pets, no children, no commercial activity".
But certainly if a filmmaker was upfront about their project, submitted proof of insurance, put down a damage deposit, agreed to pay commercial rates, and was honest about the number of people who would be there, I'm sure there would be hosts who would be interested.