FWIW, the first thing I do when I arrive at a hotel room is to put the Do Not Disturb sign on the door handle, where it stays for my entire trip.
I have zero desire to have anyone enter my room at any time, for any reason, while I am paying for it.
In some longer stays (4-7+ days), hotel management will actually require housekeeping to enter. Fine, OK, I get it. But I do not wish it.
I don't claim to know how common my preferences are, but it seems likely to me that most guests don't care a super lot about maid service, so it's a natural thing to dial down.
That’s thankfully turning around. We were just in a hotel for a few days and they offered to turndown our room each night which we declined as we don’t really make a mess and it was only two nights.