This ^ anything else is just wanting to play with tech instead of solving the problem immediately. Which is fine, sure, but that radio doorbell (or better, 3 different ones for different priority levels, since it seems important) will fix the issue right now.

This project is also a reason for me to play with LoRA, hence the ESP32, but point taken, certainly.

Rather than do that I would probably hard wire it if the Internet and LoRA are not sufficient.

Or a lamp, an RGB bulb, and a quick app to make a widget to set the color for the low-urgency requests.