I had the same problem with Vista, had to do it manually.
I've had mixed success with Windows 7, sometimes yes, often no. When I put it to sleep manually, it will come back to life on it's own, sometimes almost immediatly.
Could it be Microsoft running something? I guess I can always shut it down, but if it's M$, no doubt they will start it up again.