I also never get locked out. Usually I key myself in with the keypad, and there's a normal key slot too. It's also powered by a 9V -- but will also indicate to HomeAssistant what the battery level is
The key isn't that connectivity is bad, the key is that it should degrade gracefully when the more advanced features fail. Wireless is down? Can't unlock with my phone, but I can still use the keypad. Battery is dead? I can still use my physical key.
The other rule is that no cloud service ever be necessary. I want heat & lights, even if the internet is out.