I tried installing Leopard a few weeks ago on my main production machine. The machine needed a reinstall anyway, to clear up over a year's worth of cruft, so I figured I may as well upgrade to Leopard at the same time. The first week or more was fine, and then InDesign CS2 spontaneously developed a problem -- it would crash whenever the "file open/file save/etc" dialog would open. I switched over to using the "Adobe Dialog" for awhile, but that didn't consistently fix the problem. I did the usual InDesign fixing steps: deleting preferences, making sure the drives didn't have errors, etc. Deleting prefs would temporarily fix things, but a few hours later the problem would reoccur.
So last night I backed the drive up, reinstalled Leopard, and reinstalled just CS2 and a few other minor essential apps. It worked fine, again, for a few hours ... and then it developed the exact same problem.
Leopard has been [mostly] fine and fun on my laptop, but I don't have time to dicker around with my main production machine. It's just not ready for my prime time: whether that's the fault of Apple or Adobe, I don't care. I'm reinstalling Tiger now.