TIL standby mode. Is that enough to operate a remote webcam? Not real time video feed but say uploading a photo every 1 minute or so

Depending on a whole bunch of things but a 200KB photo once a minute might be in the realms of LoRa. You could get the data out for free.

The 500Kbps of Starlink would be close enough for a 500KB photo every 10 seconds or so assuming typical packet overheads.

For security applications where most of the image doesn't change, 500 Kbps is fine for low resolution video streaming.

Apparently you get unlimited data capped at 500 kbit/s. So that would be a clear "yes".

You can find something similar with IOT sims. And then you just need a standard 4g/5g dongle/router