I think there is a larger issue with resuming from sleep going on...
My experience moving from Vista to Windows 7 has been horrible.
I installed Windows 7 32bit with AHCI support in the BIOS (Asus P5Q-EM board) and the last Intel IMSM drivers (clean install).
I found that after resuming from S3 sleep, my Lite-On DVD-ROM was not detected. I removed the Intel IMSM drivers and the result was that the DVD-ROM was detected but the second hard-drive (where I store my TV recordings) was not. There are lengthy threads on other forums about this issue.
I finally reinstalled everything with only Enhanced/IDE support in the BIOS and now my storage device issues when resuming from sleep are gone.
Unfortunately, now I have problems with the Intel HDMI audio/video device.
When I resume from sleep the Intel HDMI Output device results "Not Plugged in" and the sound is gone until I reboot the PC. Sometimes I also get the black screen issue.
I am surprised about all these problems across different Windows 7 hardware subsystems (storage, audio, video).
I think that Windows 7 does something different from Vista when going to sleep and I think that several drivers do not support this change. Probably they behave like they behaved on Vista. What I find incredible is that no one tested resuming from S3 sleep. Come on, we are not talking about small things, we are talking about hard drives missing and screens going black!
My suggestion for everyone having a working Vista installation is not to upgrade to the "best version of windows ever"
until all these issues have been solved.