Hello, sorry to bump this old thread back up, but shortly after I believed the issue to be resolved, I again started getting BSOD when going into sleep mode. So I uninstalled ESET and put Security Essentials, but this did not resolve the issue.
This time, however, I noticed the message in the BSOD was "DRIVER POWER STATE FAILURE," so I did some googling and went with the Diver Verifier guide here on the forums. After using it and reading the BSOD dump file from the crash with a dump file reader I found, the highlited red filename was not only ntoskrnl.exe, as all the previous dump files claimed was the issue (everyone says that's a critical windows system process and is usally an incorrect reading), but also wmBEnum.sys with a "Address in Stack" of WmBEnum.sys+28b8.
So I looked it up, and wmBEnum.sys is the "Logitech WingMan Virtual Bus Enumerator Driver." I searched in my device manager and found "Logitech Virtual Bus Enumerator Drive" under "System Devices. I disabled it, uninstalled it, verified my Wingman joystick still worked (this was not the joystick's driver apparently), restarted the computer, and now it goes into Sleep Mode just fine with no BSOD.
Thought I would put this up here for other people's reference in the off chance that someone else might in the future googe around for a solution to a similar issue. I'm not sure what the whole ESET thing was about. I guess I'll install ESET again and see what happens, but Security Essentials works fine I guess.
I have to thank you and the sevenforums for having all this useful information up here that let me solve this, thanks!