No problems... with one caveat.
If you have a network drive mounted, unplugging the ethernet cable while sleeping, and failing to plug it back in before waking up, can cause the Finder to hang.
This is in fact a problem in Tiger. I don't know if Leopard fixes this or not.