So, not a trouble free update then. Straight after updating it became obvious that all was not well in CS3 land, with all the component apps quitting on launch.
After trying all manor of fixes it appears that there is indeed a (major) issue with this update and CS3, rooting in the system serial number checking. Should your copy of OS X have a serial number less than 12 digits or with a # in it, then CS3 falls over.
Obviously with Adobe "not supporting CS3" their solution is to move up to CS5. Apple have issued 10.6.3 v1.1 but this has not fixed the issue.