http://snowleopard.wikidot.com/ has a comprehensive list of software compatibility with Snow Leopard. It clearly lists Adobe CS3 as compatible, but I had issues with specific and necessary CS3 Commands in Leopard, so take this with a grain of salt.
I just want to say that even though I’m the biggest Mac guy you’ll ever meet, I don’t upgrade to a new system until release + 1 month, if then. Too many things can go wrong.
I bought the upgrade already but won’t install it for a bit. Concerned about Office 2008. This was useful though Kevin … thanks!