IMHO go with dedicated hardware for security and integrate with HSM for convenience, striving for local integration where possible. I don't think Arlo is a great solution - your only integration path is IFTTT. It actually works pretty well for convenience but I don't think I'd rely on it for intrusion detection.
Have you looked at Ring? I can't vouch for it personally (I use a vista 20 dedicated panel) but many folks seem to be happy with it and there is community-supported integration with HSM. You do not have to use their monitoring service, though I don't know about cameras. You could definitely use HSM to trigger alerts to the HE app, or use a third party like Twilio to send SMS alerts.
https://community.hubitat.com/t/re-release-hubitat-ring-integration-unofficial/