The Magic Packet really does work. So far it works for an HP computer, I believe I have set in its BIOS to Wake-on-Lan and all WOL options are turned on on NIC adapter (device manager), for the host computer.
Then when someone accidentally puts the computer to sleep (may even work with powered down pc as well), I just googled and installed a Magic Packet Sender freeware, entered IP, and VERY IMPORTANT, the MAC ADDRESS!!! of the remote computer, and click Send, voila it works!
Side note: How did I get MAC address remotely? I tried searching, using ARP -a, but this only gives you a table of active workstation addresses, not sure Windows keep a logs of workstations MAC addresses that are connected to it. So I thought, let's check the Router, and bingo! Some router keeps a log, perhaps briefly, of recently disconnected devices and thus, their MAC addresses as well.
Question will be if this is only working for certain computers like HP. I remember setting this WOL options in BIOS of other brands of PCs but failed, despite them having such WOL option.