Adobe has just posted a PDF to their website regarding Leopard compatibility. It Looks like most of the CS3 packages will be fine after an update or 2, but CS2 and Older (including Macromedia Studio 8) are marked as “Likely to encounter issues to which there is no solution” and “Not Designed” [for Leopard]. If you are running CS3 Web Standard, it looks like you are good to go, while most of the other packages require updates, however, some of the individual CS3 apps are OK. (including Photoshop and Illustrator).

Thanks, pilotzen

You can download the PDF from the Adobe homepage.