Hot take : almost no one actually needs security cameras in their home.
For the very few who do, visible fake cameras do 95% of the job of real cameras with none of the drawbacks.
EDIT : I'll go even further and say an official looking sticker / plaque that says something like "this house has cameras" does at least 50% of the work already.