In essence yes, but I will disagree on it being an OS issue. In a paradigm of the "Magic Packet" then yes the OS should not wake on anything but the "Magic Packet" we agree here.
In a paradigm were the computer performs a vital service, but only on occasion, in the case File Server and/or Print Server, it is beneficial for the computer to come out of sleep mode to perform its service based on the network traffic to it. In short, wake up, here is some work. I do not believe, Linux, Mac or Windows prefixes its work traffic with a "magic packet", so someone, in this case me, would need to make a choice, write a rather (understatement) complicated program(s) that new that the work was going to be performed and the worker computer was in sleep mode, then issue the "magic packet" before the work was actually started.
OR I could write a service/program to stay in memory and pulse the Worker Computer with a "magic packet" on a periodic basis, in essence forcing it to stay awake as long as any computer was turned on.
Obviously the later is ... simpler to do, but if the worker computer on average was required to be on 1 hour out of every 24 hours and computers could be on as much as 14 to 16 hours, then the worker computer is on far longer than it needs to be.
If the DLink is doing this then I agree it would be great to have the option to turn it off.
On the other hand, this Atom 320 is using about 80% less power being on than the obsoleted Celeron computer it replaced so it is achieving its goal but it could be better.
Yes it is Windows 7 Ultimate (way over kill but ...) 64 Bit. All computers but one are W7 Ultimate 64Bit except one that is XP 32Bit.
Here is the rub. I very much want the Atom to be Linux BUT SAMBA screws up the Printer service for any and all 64 Bit OS's. They have acknowledge the problem and have stated it will be resolved, just not in the immediate future.
Windows 7 is only marginally better. It will connect and install the shared printer, but if you make any changes to the printer preferences then the printer will go off-line to the computer making the change.
There are two work around, delete the printer and re-install it, make your change and print
OR
Restart the print spooler.
Neither solution makes me a happy camper as there should NOT be the need for a workaround.
SAMBA not getting it right, after they did have it right in a previous version but changed how something was handled and that screwed up the 64 bit printing is annoying as Hades as I really do want to put Linux on that box.
IF DLink read these then I would STRONGLY suggest they use a PRIMARY ISP DNS as the 2nd DNS, and their secure DNS as the primary. Role down to the 2nd DNS if the Primary DNS goes off line *cough* as it has done. Because it doesn't do this, I need to keep the Advanced DNS set to off as the last thing I want to hear is how no one can get on the internet.

Again, I like the idea behind the Secure DNS and would use it in a heart beat, but again, the last thing I want to hear is how no one can get to the internet.
For the record:
Sleep in this context is all power is turned off except to the NIC and to memory. Or in short, just enough power is on to keep memory stable and detect a WOL, providing a rapid wake up.
Hibernate as I think you are using it would write all memory to disk, do a standard power down, then on WoL do a standard resume by reading memory from the hibernate file a longer process but a further reduction in power. In my opinion, powering a single 2GB ram stick probably does not consume that much more than the hibernate mode. On the other hand the resume is ... noticeably faster.