It's happening to me with my Z690 extreme. Everything runs fine after reboot. The only difference with you is that i'm running a high performance power plan.
I'm gonna try something i read in a different post
Hi Iecapici, how have you established memory stability?
Failure to come out of S3 resume could be a sign of an unstable overclock. It can occasionally be difficult to catch in OS based stress tests if it's related to refresh (tREFI).
You'd need to confirm whether the same behaviour is replicable with the system at stock, i.e. Optimised Defaults, no XMP or overclocking.