I'm using a shuttle FN95 motherboard - SN25P box, which is a old socket 939 combo. I suspect there's not many (any?) other who use this, but it does require getting the very latest bios to get sleep to work. Previously it would sleep, but not wake up properly.
The script does work, but it has some deficiencies. The worst is that there's a possibly of immediate sleep after the hard drives all spin down if cron happens to fire it off at that time. I'm going to rework this to instead have the script do a while loop, check every minute, and do a countdown to prevent the immediate sleep/spindown. Also need to figure out a more generic way of iterating the hard drives instead of hard coding it. And probably put it hooks so it will auto execute scripts right before sleep and right after wakeup.
Magic-packet generation will probably be the biggest headache for most users. My OSX boxes have a handy WOL widget, but its not obvious how you'd do this from a TiVo or other media box.