IMHO if Microsoft wanted this it is clearly them to blame. It is a bit like going back to the MS-DOS era where applications should behave as there was no memory protection.
The simple/partial solution is: if the system is in S0ix (modern standby) state then under no circumstances it is allowed to get warmer than some reasonable temperature (i.e. 36°C / 97°F) - a fan should absolutely never spin up.
That is clearly on Microsoft and Intel to omit such an obvious limitation.
The problem usually isn't that its heating up while in that sleep state, the problem is applications then request to change the current state to a higher power state.
Sure, keep S0ix in a low enough power state that it can easily be passively cooled and not allow it to get high enough. What's to stop that av software to once again decide "S0ix? Nah, need to scan NOW, WAKE UP!!!". If there's any way to change these states in software, the apps causing hot bags today will just move to call that instead.
I would argue it is still a problem with the sleep state if it is allowed to be changed by software without restrictions. If the user decided to put his machine in the S0ix state there should be no way other than opening the lid or pushing a button to change it. Maybe there could be a hatch to allow the user to select what has higher privileges. I would worry that the corporate mandate would make all kinds of things in there, so I would vote against that. In general either you fit inside the state or you do not get a ride.
AFAIU not every app can be a driver and most probably no app you installed without administrator rights. There could also be an easy restriction that there can be only one lid open driver or limited to the manufacturer. There are lots of things that could be tried and I will not excuse a billion dollar company that mandates S0ix in the first place.
I guess also that most things that do wake the computer up aren't really doing anything fancy, but Windows just is too nice for them.
The simple/partial solution is: if the system is in S0ix (modern standby) state then under no circumstances it is allowed to get warmer than some reasonable temperature (i.e. 36°C / 97°F) - a fan should absolutely never spin up.
That is clearly on Microsoft and Intel to omit such an obvious limitation.