Adobe has announced what will and what won't work with Leopard.
What will: Photoshop CS3, Flash CS3 Professional, Contribute CS3, Dreamweaver CS3, Fireworks CS3, Flash Player 9, GoLive 9, Illustrator CS3, InCopy CS3, InDesign CS3, Bridge CS3, Version Cue CS3, Device Central CS3 and Acrobat Connect (Start Meeting).
What won't: Adobe Acrobat 8 Professional, Adobe Premiere Pro CS3, After Effects CS3 Professional, Encore CS3 and Soundbooth CS3.
Concerning the "What won't", Adobe expects to have updates for their video-based applications sometime in December 2007, while Acrobat 8 Professional is slated to be updated by January 2008.
As will all major upgrades, make sure that ALL of your applications AND plug-ins are Leopard compatible BEFORE you upgrade.
Downtime is bad time.
Erik