> Microsoft wants it this way so they can maintain network connectivity
I liked coolness of "Connected Standby" - laptop sleeping, but playing music over bluetooth. Other than coolness, cannot say I found much use of it - may be my ssh didn't terminate? Don't remember.
The windows created S3 sleep debacle was annoying. But it's long since solved. Lenovo ships both sleep options in bios now and Linux distro a support both sleep styles because they have different drain profiles.
Then again, I'm typing this on a 2019 Macbook Pro (Intel) that has nary a single replaceable part.