I would recommend, as a first step, disabling connected standby, to see if that makes a difference:
Other thing to check is whether the network card is set to turn on the computer (as it’ll need to keep it powered to do so). See Device Manager->Network adapters->Intel Dual Band…->Power Management (and turn off “Allow this device to wake the computer”), and in the same diialog box in advanced tab, “Wake on Magic Packet” and “Wake on Pattern Match” should be set to “Disabled”.
One thing to note is that in sleep mode, the system needs to keep some components powered, so there will always be some form of battery drain. Your android tablet sounds exceptional - most tablets have battery drain when they are not fully off.
If you want to make sure that your PC has no drain, you can change the power settings so that it goes into hibernation mode after a period of time. When it’s hibernated, there will be no battery drain. And perhaps that’s what your macbook was doing.