While I don't like Windows much and dual boot it mainly out of necessity, it was pretty easy to whip up a trigger (in the GUI task scheduler) for a script to trigger alarm music even when the computer was sleeping.

The procedure goes something along the lines of "RTC trigger wakes up sleeping computer, computer waits to connect to network, opens spotify url of playlist." It lets me turn off the LED and fan nightmare that is my desktop and still use it as an alarm.