As I stated, I see the same complaint from many other users. I've experienced it myself off and on with 2 different cards. Sometimes it seems to work correctly, then a driver update seems to break it again. I don't have a solution for you that works consistently.
I leave my PC on nearly 24/7 so if it bothers me I just turn the monitor off when not in use. I much prefer the issue of the monitor not going to sleep, rather than the monitor not coming out of sleep. That issue was solved by using either 22.11.2 or 23.11.1 so maybe you can try one of those versions.
https://community.amd.com/t5/drivers-software/monitor-fails-to-resume-from-sleep-s3-mode-with-23-2-2...
Ryzen R7 5700X | B550 Gaming X | 2x16GB G.Skill 3600 | Radeon RX 7900XT
Ryzen R7 5700G | B550 Gaming X | 2x8GB G.Skill 4000 | Radeon Vega 8 IGP
Ryzen R5 5600 | B550 Gaming Edge | 4x8GB G.Skill 3600 | Radeon RX 6800XT