When the kids were little we enjoyed daily housekeeping because they usually did cute stuff with the kids toys, made them towel animals etc. We contemplated
DVC nearly every visit and no daily housekeeping was a downside for us. Nowadays, we always put our DND sign up (all hotels) and call down to request towels when we run out. We don't put anything that would rot / stink in the room cans, so they typically don't need emptying. Basically, we prefer no housekeeping.
That being said, if this improves our safety, so be it. If this helps reduce damage to units that costs members money, so be it. This at least makes some sense to me. I'm much more worried / annoyed about the dog-friendly issue than this one.
I would hope that they will be reasonable about the room checks. If they come by and the latch is on, it seems they could mark that the room wasn't inspected and a list of the rooms that were "missed" could go to someone in charge to call your room and ask that you schedule a return time within X amount of time. It should be understandable that people need to shower and change, have babies napping, etc. Honestly, with magicbands, they should know when you all leave your room, so you'd think they'd really try to do the checks when you are gone. As for guests, they shouldn't worry about the room being messy. It's not like housekeeping is trying to clean around it.
I really do feel bad for families with napping children. That really sucks to have to worry about them being woken up. I wonder if guests could be proactive and call down to the desk and request a "do not disturb" for an hour or two because of a napper. I'd at least try it.