My plan was to stick the Pi inside, and power both it and the camera with Power over Ethernet (external-rated PoE cameras are a dime-a-dozen on Alibaba and friends).

I even got so far as to get it working with Zoneminder to dump out the clips that had motion, but didn't get further.