Yeah, the only way to get it to work reliably is to also employ other energy-saving tricks, like using a Sleepy Pi HAT and a rechargeable battery. The cost starts inching towards $1k+ at this point (not to mention the time involvement as well).

However, it's definitely doable, and if you have something like a year-long construction project... it's not really that expensive for what you'll get in the end!