I recently moved away from MyQ to local control of my garage door and I've been loving it. I stumbled across the linked issue where MyQ shit the bed for roughly 3 days and it just confirms to me that the extra effort to move away from a cloud service was worth it. I'm down to just one last cloud service for something inside my house. My mind is pretty much made up that if I can't accomplish it locally, I won't do/use it.
Personally I’ve been pretty happy with Unifi Protect. Reliably records locally but accessible remotely and notifications are quick within a few seconds. Cameras can connect to HA and support RTSP if you want to link them into Frigate.