If you’re looking for a simple task to run at certain time, you could take a look at my scheduler integration:
It offers exactly the run once + delete / disable after execution options which you’re looking for.
I think it might take a while before such feature will be available for standard automations.