Tbh, I don't know. The last time I used a desktop on a daily basis was 2020, and that was just my work PC where I wouldn't really care if it woke up while I wasn't at work.
The last time I had a desktop PC at home was in 2009, so I really can't say what is happening there in the meantime.
And at least to me, sleep on a laptop is much more important than on a desktop. Battery usage isn't really a thing on a desktop (usually at least).
Interestingly, I do own a little 2010 netbook that I use as an ultra-mobile laptop when I really don't need any kind of performance, and that one does all sleep states including hibernation perfectly out of the box. Even when just sleeping it loses maybe 1-2% of charge per day.
But all the other laptops I own suck when sleeping.