Let's do this somewhat logically...
Main Causes for Kernel Panics:
http://www.thexlab.com/faqs/kernelpanics.html
Defective or incompatible RAM - checked
Incorrect permissions or bugs - checked
Incompatible, obsolete, or corrupted kernel extensions - I too started getting the KP's recently, after installing CS3. Coincidence? Maybe...This is what drew me initially to this thread, seeing that you had Dreamweaver CS3 and Fireworks CS3 running when it first happened. (I thought maybe it was the airport issue for me but that has still yet to be confirmed, the only changes I've made recently, is to add CS3)
Incompatible, obsolete, or corrupted drivers - same as above. If you had the older version of CS 2, then upgraded, which I did, maybe there are outdated drivers that are causing this.
Insufficient RAM and available hard disk space - you're running CS3, with a 100 gb hd, 2 gb ram, on PB G4, possible... but the fact it still happens with no apps running doubtbul
Hard disk corruption - possible
Improperly installed hardware or software - possible
Defective hardware - seeing that the computer works fine until it goes to sleep, doubtful in my opinion
I'm currently trying to understand the log file more, I'll let you know if I find anything else out.