There's no way my wife would allow all those wires everywhere. And the wireless security cameras are a pain because you have to remember to recharge them.
Now, before the wannabe This Old House crowd starts up with "You just put the wires in the walls," consider that 43% of Americans rent their homes, and the number is even higher in other countries. The vast majority of landlords won't allow you to run wires in the walls.
That said, there's NFW I would have one of these in my house because I don't trust any tech company to have a camera in my house.
It's marketed as a security device, but it's not like a toy quadcopter is going to stop an intruder any better than a non-flying camera. Which means "not at all."
If you want home security that can reach all parts of your home, and provide alerts when someone breaks in, get a dog.
No, the dog can't alert you when you're not home, but again, it's not like you can do anything about a break-in when you're not home either way.
Then again, iOS has the built-in ability to detect dogs barking and react to that. Perhaps in the not-too-distant future, your Homepod can detect the dog barking and hit you with a text message.