How old is your machine? If it’s new enough to run windows 11 then it probably also supports modern standby (aka S0 standby). When plugged in during “sleep” it’s actually on, and should be doing the updates for you.
That said my work laptop only gets used during work hours and it almost always gets it’s updates done while I’m doing stuff throughout the day, and it just needs a quick reboot to finish.
I turn off modern standby. I don’t want my computer turning on when I am not around or when I am asleep. For laptops, modern standby is famous for turning it on while its in your laptop bag, causing overheating and battery drainage.
I think if an update process is annoying enough to require something like Modern Standby in order to be “seamless”, it needs to be improved.
