@James Martinez yeah your instinct is right and the approach you've already outlined is basically what I'd do too. At 50-200m you've got so much link margin to burn that you could probably drop TX power by 10-15 dBm and still have a rock-solid connection, which translates to meaningful current savings on the radio side.
The threshold-triggered approach is genuinely simpler to tune and debug than a full closed-loop adaptive system — just pick a conservative RSSI floor like -80 or -85 dBm as your "kick up" trigger and you're done. One thing worth adding though: build in a little hysteresis so you're not toggling power back and forth if RSSI is bouncing around near the threshold. Something like "kick up at -85, step back down only if RSSI holds above -70 for N consecutive readings" keeps it stable without a lot of complexity.
Also worth thinking about is your supercap sizing against worst-case cloudy stretch — the Power/Program Kit's 5-min charge / 24-hour runtime spec was designed around running the full module stack, so if you're already using that, your headroom is probably better than you think even at higher TX power. But yeah, lower power for normal ops is just good practice regardless.