I had some serious issues with Photoshop, InDesign, and Illustrator CS3 under Leopard on my PowerMac G5 -- they would unexpectedly quit immediately upon launch. After some research I found out that others were having the same issues related to Leopard, that Acrobat 8 doesn't work at all, and that Adobe said it would not update CS3 to full Leopard compatibility until early 2008. I don't know if it's happened yet, but since we just clocked into January I assumed it hadn't yet. I also was unable to successfully print to the Adobe Acrobat driver, which is incremental to a lot of my workflow.
I'm glad those apps are working for you, but for me they just crashed and burned even after a clean Leopard OS installation. Now I'm happily chugging along after downgrading back to Tiger and CS2, and will hold off on any Mac Pro purchases until Adobe and Apple can sort out this whole Leopard thing. There is a SERIOUS need for Apple to create competitive versions of these applications and make them cross-platform to give us an alternative to Adobe. If Adobe pulls the plug on Mac development, or just stops caring (some will argue it's already stopped caring), then the Mac Pro will be relegated to running a handful of Apple pro applications and otherwise being nothing more than a status symbol among Mac people.
It is possible that the Intel build of Leopard doesn't have as many issues with itself or Adobe applications -- the Mac Mini which I purchased recently to run my phone server under Linux virtualization seems to be better at running Leopard than my dual G5. That really surprised me.
By the way, the Mac Mini makes for a fantastic VOIP PBX server using Linux virtualization and free, open source solutions. Check out
PBX in a Flash. I can now run my business from home, have all the calling features I could ever want or need, and all for under 1¢ per minute!