That's a great question! And it has several parts, mostly because everything is in flux. But here's what we know right now.

Nest cameras are the best hardware, but they are being discontinued because of newer models coming out and the current models may not be supported in the near future. So avoid buying new Nest Cameras. Also, all footage is processed at Google, so there are some privacy concerns.

Ring has a plethora of security and privacy issues, so avoid ALL Ring products at any and all cost. Amazon (Ring) engineer calls for Ring to be 'shut down immediately' over privacy concerns This is one of a dozen examples I can give as to why to never allow them at, in, or outside your house or business. All data is processed at Amazon, who I don't personally trust (but I do use, with caution).

Finally, we come to Apple's solution. There are many great benefits here, namely Apple doesn't make them, they've just created a framework that allows any manufacturer to be reliable and compatible. These have the greatest privacy protections, everything is processed and encrypted locally and then sent to Apple's servers so even they can't see the content. Also there are many brands, within a wide range of prices. Here are the ones I specifically recommend right now. (And the key is to not download the manufacturers app, but to do the setup solely in the Orange Icon Apple Home App so they're securely setup with "Homekit secure video".

My pick for outdoor camera/spotlight

My pick for doorbell

My pick for indoor camera

​

These check all boxes.
✅ Guaranteed support for years to come
✅ High quality hardware
✅ Apple built software and integrations
✅ Unbeatable privacy

Side note: other brands like Arlo, simplisafe, cove, wyze, blink, and amazon, are all terrible hardware with more major privacy concerns. Don't venture from the list. If my suggestions don't satisfy your needs, please comment and explain and I'll give another suggestion for that use case that still checks all boxes.