I recently proposed this opcode as OP_Expire for use in lightning channels: https://lists.linuxfoundation.org/pipermail/bitcoin-dev/2023-October/022042.html

While reorgs are a concern, that problem can be easily avoided by making the outputs of expiration-using transactions unspendable for a period of time. Similar to how you can't spend coinbase outputs in blocks immediately.