Im running adobe cs4 master collection since i had leopard. Updated to snow leopard and every single adobe app runs with no problems, no re-installation required
edit: actually i updated to 10.6.1 right after upgrading to SL, so im not really sure if there would be any problems prior the update. I can ensure that all cs4 products run just fine on 10.6.1 though