It would be great if ESPHome automatically handled updates for devices that go to sleep.
It could work something like this:
In ESPHome - mark device to auto-update next time it is online
on the device itself have a config section that would say, next time you are online (or once a day or at specific time, or once a week, etc) check with the server if there are updates and if they are install them then go to sleep.
I know that there are workarounds involving MQTT or scripts but this should not be this complicated.