Unfortunately I'm not aware of anything with this kind of functionality. A church I work for has this kind of setup but I don't know what company makes it and I'd guess it's far more expensive than Ring and a smart lock.

While it may be common in Mexico, it's very uncommon here, as far as I know, except for commercial installations.

As much as I love home automation, these days you won't find products made for you if you don't live in an apartment in a US city. Basically if you're not like the people designing this stuff.