We had this (thankfully an optional addition to physical keys) at one of my previous buildings. The failure rate was maybe 2% but still way too high to trust for regular use.
The locks also ran on batteries, which a technician came out multiple times in the ~year I lived there to replace. Overall was a nice add-on to the physical key for e.g. guest access but the economics of these things given the battery replacement seems dubious. If it ain't broke...
Airbnb vs. hotels is like Mom and Pop restaurants vs. fast food to me. You might have a better experience at the former, but you know exactly what you're going to get at the latter.
My last Airbnb went perfectly smoothy but there was still a ton of communication with the host. And that was only part of a dozen+ emails and a similar number of app notifications related to the stay. Why? At some point I just want to show up, crash, and leave.