For a device to be able to wake a Windows system, it has to be allowed both in the BIOS and also in Windows's device manager (In the "power management" tab on a device, the checkbox on "Allow this device to wake the computer" has to be set/unset). It is available only on certain classes of devices.

Also what you are referring to as an application's capability (Foobar...) to wake a computer (from sleep or hibernation only) it most probably has to do with setting an RTC (real-time clock) alarm and the computer being allowed to resume from such an event. Again this is also a setting which can be disabled in most BIOS configurations and yours probably is. By the way, Windows' task scheduler exposes this option to everyone so you can set your computer to wake up and run some script and then sleep again (I used to do this all the time ages ago for night downloads, etc.)

So, there are a series of switches (in BIOS and in windows device manager) that all have to be set/unset, for a computer to resume from some event;