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.
I have Blue Iris NVR with Reolink cameras. A bit of tweaking, but it was easy to follow tutorials online and they integrate into HA nicely. Blue Iris isn’t free, but I couldn’t get Frigate to work and don’t have the background to troubleshoot it very well. I’d say it’s worth the cost, though.