Reading this has reminded me of something I wanted to explore in the past. Most of my applications/requirements for a Pi include GSM, but I've found GSM modules to be very expensive, often being more expensive than the Pi itself. The author mentions a mobile USB modem, and it's just dawned on me that older 3G/HSDPA dongles are often very cheap. Does anyone have experience using them, especially what power implication…
Regarding USB dongles, I've been running Huawei E3131 with RPi. I needed to put +5V directly onto the pin header, but maybe now with the USB-C RPi4 the power should be stable out-of-the-box. I have heard rumors that the modem freezes after a while, but I've never ran it for longer than a few days. I'd recommend either investigating whether you can hard-reset the modem with software (cycling the USB power) or even putting a watchdog that will cut power to the entire RPi.
Regarding power consumption, SIM800L is fine in idle, a few mA. However, USB dongles AFAIK do not support power save and they will eat ~100 mA all the time, which might be a significant portion of your power budget.