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.
Have you checked out Frigate? It’s a local service that captures RTSP streams from cameras and uses neural net image recognition to trigger events / recordings. It has good integration with Home Assistant.