Hmm... I've got problems with sleep too after updating to 10.6.5. Sleep worked like a charm in 10.6.4. My iPC :D goes to sleep but wakes up for about 3 seconds every two hours.
Installed with custom DSDT and three kexts: FakeSMC, JMicronATA and Legacy889aHDA.
Any help is greatly appreciated...