If price is important, use Wyze Cameras. For $25, their video quality rivals that of cameras costing hundreds of dollars.
They can record to a micro SD card in the camera, so even more privacy than sending to any cloud, even iCloud.
At $25, they are impulse buys / throwaways. You can add cameras to do fun things that you would never buy a “real” camera for:
Put one in the garage to see if the garage door is open or shut - safer than a garage door opener that can be hacked give that the biggest need is to confirm the door is shut after you’ve driven away and half way to work.
Put one in the laundry room to see when the washing machine or clothes dryer is done. Aim at the control panel/display!
Put one next to a printer that is in another room so you can see if the printout is done or paper jammed without walking over to it (“first world” fun)
Many people use them outside anyway because when/if they break, just recycle and replace. (Amazon also has lots of cases/enclousures - some that look like tiny bird houses.)
OTOH, if you want serious security camera solution, then I can’t recommend Apple HomeKit. Both the current “HomeKit compatible” cameras have severe limitations and the new “HomeKit Secure Video” is very raw. It is buggy, feature limited, and unreliable. Total embarrassment that Apple could release such a limited and unfinished product.
There are many security cameras with iOS and Mac support (native apps) with a range of capability and price. - Just not HomeKit compatibility.
Be really in love with Apple if you want to reduce all your choices to the lowest-common-denominator of capability provided by Apple HSV.
And the snail’s pace of HomeKit improvements (yearly cycle or longer) means improvements, even incremental, are not expected until the fall of 2020.