Smart Lock recommendations

Looking for recommendations on a HA compatible door lock, both office (semi-commercial) and residential.

Features:
Individual access codes for different IDs
Keypad in case a smartphone or RFID is not available
Programmable / Restricted access days/times
Access log (mostly for personnel entry off hours)
Keyed access if power fails

I’m OK with something from Lowes/HD if there’s anything that fits the bill. Looks like the Schlage Connect might do the trick. Looking for feedback.

Thanks in advance!

Bump. Still looking for a solution, now only for my home. Need exterior doors and one interior door that can be controlled both by app (remotely) and via HA. Would like the app to be able to track activity and also assign unique codes for multiple users.

Hope someone can help point me in the right direction. Thanks!

I was just thinking about whether there are any interior door lock options.

Mostly I’ve finding levers with keypads. I wouldn’t mind it being even less secure (and less obtrusive) though - think I’d like a bathroom door lock.

https://www.amazon.com/dp/B004F1F1PY/ref=cm_sw_r_cp_api_JLkFAbN77R2H9

More or less what I’m after, but the price on that one is crazy. I saw this one which made more sense to me, but what holds me back is having a mix of locks from different vendors. So, if I wanted this one for internal doors:
https://www.amazon.com/dp/B0B8R7KLK5/?coliid=I37G6HUNIOM2AG&colid=57XKZQ3CPQVA&psc=1&ref_=lv_ov_lig_dp_it

I’d want this for my exterior doors:
https://www.amazon.com/Schlage-FE469NX-LAT-619-CEN/dp/B00D1M5ZNG/ref=sr_1_7?crid=29TF8955EA08U&keywords=schlage+connect&qid=1675432639&sprefix=schlage+connect%2Caps%2C117&sr=8-7

The problem with either is that I’d need to access the locks from outside the house if locking or unlocking is required when I’m not home. Having to juggle different software from different vendors is a PITA and the caveats about making HomeAssistant accessible from outside the internal network scare me a bit.

Still open to ideas…