@RearAdmiral, Tim, what kind of internet connection do you have? How much do you want to depend on a subscription of a cloud service?
Most of the Foscam cameras has option to install micro SD cards for local storage, and you can buy Foscam NVR to record the feed from the cameras locally on the network.
I have 4 pieces FI9900P and an NVR which has continuous recording. But Foscam offers cloud storage with different kind of subscription options too, but it requires a stable and high speed internet connection and a paid monthly fee.
I have no experience of the human detection, but the motion detection can be tricky or bad, if you use the cameras outside. I have continuous problems with spiderweb in front of the camera during night time, when it is windy or the spider does a walk around. The IR makes the web shining and if it moves then it triggers the motion detection. Maybe mine is an older model, but it has some quirks. Either you need to clean the spiderweb often or reduce the sensitivity of the motion detection. By the way turning on an off a light in front of a camera during night time with the IR on can trigger motion detection too. Of course you can define zones for motion detection, but these cameras are not really “state of the art” solutions. For that you need to pay big bucks. They are perfect for monitoring and CCTV purposes.
The best what you can do is to check them somewhere where they are installed and used continuously or maybe order one from amazon and try it first. If it doesn’t fit for your general use then you might be able to return it with amazon.
The old ones works with the Foscam app, but full feature settings can be only done from a Windows PC using Internet Explorer only. That might have changed with the newer models.
Read some reviews and try to get one for testing.
They integrate well with @RBoy’s DH. You get motion detection, you can take still shots. If the camera support PTZ then you can move it with the DH too, power on/off and reboot, and IR options. And you can watch the feed too if you make the camera accessible from the internet. Basically everything what you can ask for.
You can define email alerts to be sent with pictures from the cameras setup menu and schedules too. It has all kind of functionality what anyone can ask for.
The best is to try it first.
I have no experience with Arlo or Nest cameras, but I think they are different league. They more for cloud and subscription use. Foscam does a basic job fully locally (not the DH locally) with multiple integration options.