Mode aside . . . I think indoor cameras are always going to be an issue, trusting any system to not record. The only way to trust an indoor camera is not recording is to cut the power. Amazon never could convince echo spot users (of which I was one) it was OK to have a camera on your nightstand (software turned off, sure), I put tape over mine, and now the new echo show devices have a hard shutter you can close over the camera.
Consider putting a smart plug on all indoor cameras, then only turn the power on when you want. Yes, one more step when you enter or leave the house . . .alexa, turn on the cameras. But the only way you will really know.
Outdoor cameras . . . I don’t care, let some employee watch my driveway if they have nothing better to do.