I absolutely agree that microsoft could and should make this work better. But the pragmatic workaround is the setting to force hibernation when you close the lid. You can resume from SSD in 10 seconds. No middle of the night wakeups. Much improved battery life.
It wasn't actual WoL. It was broadcasts. For some reason it woke the Mac up when WoL was switched on. We're taking 2015 or so so I don't have the packet logs anymore but I was able to replicate it by resending them.
So the fault is really the Mac's. It should only accept real well formed WoL packets with its own Mac address.
OK, from the comments I read so far I realize that I may have been lucky with an older laptop. And I did not mention that I also turned off wake timers, realized that now. If this does not work on modern hardware that’s a real bummer.
The funny thing is that the "modern standby" was supposed to improve the wakeup time from a couple of seconds to a faction of a second. But effectively it turned the wakeup into 10 seconds because you have to disable the modern standby and use hibernate instead.
TFA says that hibernation is problematic for putting your computer into your bag. I understand what you mean by hibernation, and while it should not cause a problem... that's what the link says
When windows is hibernated, if a scheduled task is set for a specific time, it will use the hardware wake-up feature to turn on the machine and run the scheduled task.
Windows has a lot of 3am scheduled tasks for all kinds of random stuff (disk defrag, various update checks, etc). Any of those can cause the system to reawaken.
I had to do this with my ASUS Zephyrus G14 because it's an AMD-based machine and doesn't support a true Standby mode anyway. It's not the greatest coming from the Mac ecosystem where Sleep basically just works (well, most of the time, High Sierra screwed up a lot of things around that).
To my knowledge, it hasn't woken up without my input and Hibernate doesn't eat the battery alive while it's asleep.
The problem with this is, you can force the laptop to use other sleep modes, but either
a) dell disables those modes entirely in the BIOS
b) windows update resets the sleep mode