Is installing a Unifi Door Access system for my front door overkill? Yes.
Do I want to do it anyway? Absolutely.
It seems like with a fail-secure electronic door strike, you could put a regular doorknob with a physical key as a backup in case the power goes out or the whole system goes down, and it'll work like a regular door in that case.