I think the problem is at the camera. Most of them don't have API or not opened.
There are a few more community drivers. You can search for Hikvision, Reolink, Ubiquiti, armcrest and Blue Iris which covers hundred of camera brands.
Honestly I think you are overselling the ability of the cameras without knowledge of the lack of their ability to actually allow external systems access to some of their advanced features.
That said Blue Iris has a slew of features similar to most of what you mentioned and as I understand it has the ability to be fully integrated. You should start their.
The problem is the ability to to integrate them as most systems are closed and don't allow easy integration with a system like Hubitat. Some systems do allow integration but then many of the functions you talk about are extremely limited or are not available to external systems like HE. This isn't exactly a new topic and almost every time the result is to look at Blue Iris or a similar on prem NVR system that can provide those functions.
While it is not a direct integration, Eufy cameras are accessible via ioBroker (and I suspect Node Red too) on a Raspberry Pi. You can either choose to write your automation in ioBroker (or Node Red) or create a simple pass through script and automate in HE.
I have done this and it works well. There is a bit more to setup and learning to do, but it isn’t a huge step, if you’re moderately technical, as you appear to be.
My use case was to fulfill a request from my wife. “I want the doorbell sound to be the Jetsons doorbell. “ we have Eufy cameras all around our home, but playing custom sounds isn’t a choice for Eufy.
I installed an Ecolink siren to play the sound file. It allows you to add sound files on an SD card. I setup ioBroker on a rPi, and I designed the automation to play the Jetsons doorbell sound when the Eufy doorbell sees a human approaching the door, and when someone presses the doorbell button. WAF=100.
I really don't understand your post. Hubitat works fantastic with local cameras, couldn't ask for better camera integration. Having said this, HE is not a device that has multiple terabytes of built in storage with the ability to record and manage camera feeds. People use a variety of other software and hardware for this task. As Hubitat prides itself on local solutions that do not require the cloud, HE integrates well with the major platforms in this arena. This includes Blue Iris, UniFi, and to a lesser extent synology.
It is important to realize that HE strives to integrate nicely with these various NVR camera recording/managing systems. In and of itself it is not a NVR system, nor should it strive to be.
It was fairly straightforward to implement the following when I first acquired my Hubitat (in no particular order):
Wall Tablet goes to camera view when somebody rings the doorbell
Message sent to phone if someone walks into the camera's field of view and the alarm is on
If the alarm is on and someone walks into camera's field of view, and angry dog barks inside the house.
Outdoor lights turn on when someone enters the camera's field of view (depending on time of day), also the lights that turn on and the order in which they turn on varies based on time of day and whether or not the night alarm is armed.
Many users implement more automations than this, the sky is really the limit. Not sure how much more a user would like.
maybe the right question I should ask is: What is the plug and play camera/brand that has a decent integration with HE! .. something with sensors triggering and possibly can be added to the dashboard directly for viewing..
I personally have Arlo, Nest Cam, WYZE and I struggle to get any to work with HE, these are very popular options alongside Ring, blink, eufy ..
reading your feedback here I'm very tempted to check out,
Blue Iris but for the need to run a 24/7 windows machine
Camect seems highly rated but the price point $600-$1k is steep,
now investigating if any of Hikvision, Reolink, Ubiquiti, armcrest wifi/battery options to see if any model or brand can be integrated easily with HE..
I don't mind buying another device/hub/nvr system if it would integrate HE properly .. as long as i wouldn't need to do all the wiring thing and just keep it simple with the battery cam/wifi or so..
Arlo, Nest and Wyze are examples of Cloud based solutions. So the problem is as i stated above that they don't generally integrate well with external systems.
I have Arlo and Eufy and you can probably use the same method i did to use them with Hubitat.
First I would suggest you consider using Smartthings as a potential cloud aggregator for integrations that don't exist or can't exist directly with Hubitat. To do this you would setup a cloud only Smartthings environment with your arlo camera. Then you can use HubiThings Replica to integrate it back to Hubitat. That integration method should allow you to integrate anything you can get from arlo other then Smart Notifications. They don't send that data outbound.
I believe WYZE has a firmware that support RSTP that can be used through a NVR software like Motion on a Always on system. That software can be setup to tell HE when a motion event is detected with Tiny Cam Connector.
I am not sure what to tell you about Nest as it depends on what methods are avaliable for it to integrate. If it can be integrated with Smartthings you may be able to use the same method as Arlo.
All of those options though aren't best in class solutions largely due to those solutions preferring subscription cloud based options.
I would suggest you look at Blue Iris and getting cameras that work with it. Blue iris has tone of options so it won't be exactly plug and play, but honestly I don't think you will find one that really is.
Dashboard viewing would likely be just pointing your dashboard to the appropriate URL. It generally isn't really a dashboard function, but your browser just opening the stream in what is called a iframe.
If it's your cup of tea, there is a docker container that serves as an intermediary and generates a rtsp stream for all your wyze cameras. I've been using it for a few months with BI and works great. Even audio works.
If you want plug n’ play, then I also suggest Camect and your choice of IP cameras that support RTSP and/or ONVIF. Camect’s AI processing for motion events are worth its expense.
You can accomplish pretty much the same thing for less with Blue Iris but you have to roll your own hardware, keep a windows PC on all the time, and if you want AI analysis of motion you also have to configure deepstack on your own.
FWIW although I do enjoy integrating cameras with my home automation setup, I think there are plenty of people for whom this isn’t necessarily a priority.