Hi,
this "problem" is driving me nuts as well. Sometimes I forget unplugging my USB hub BEFORE setting the MacBook into sleep mode - it will thus wake up automagically again. Waiting for it to actually wake up and setting it to sleep again is pretty annoying, as this procedure may take up to 5 minutes.
Either way, searching with Google revealed, that a lot of people would like to disable wake on USB, or at least wake on USB, iff USB is used as power source only (the whole iPod debate.)
Also, people try to suggest, that this is a hardware or OS limition, as OS X
has to process events happened on the USB bus and thus the behavior is perfectly normal. I am sick of reading those comments, as re-checking the bus for added/removed devices can actually very well be done after waking up again.
Windows, despite being a PITA most of the time for other reasons, at least gets
this right.
However, when thinking of how Apple handles User feature requests... this "functionality" may most probably never come, so I'd rather give up on this.
Best regards,
Mihai