If you are responsible for maintaining Macs in a production environment, it might be wise to take your time and do proper testing before rolling out OS X 10.8 and Adobe Creative Suite 6.
While the upgrade from 10.7 to 10.8 do not have the same compatibility issues, as the upgrade from 10.6 to 10.7, there are some problems. Some of which are related to Adobe CS6. There are three areas you should be aware of before upgrading your system:
1. Appearance of the dock changed
This is just a cosmetical issue. It is still annoying, and has users question their monitor calibrations. Up to 10.7, the dock was color managed the same way as other User Interface elements. If you placed an icon on the desktop and in the dock, they would be rendered to the screen in a consistent fashion.
In 10.8 the dock is no longer color managed the same way as the rest of the OS. If you have a laptop with a small color gamut, the icons in the dock will seem unsaturated. On a high-end wide gamut monitor, the effect is the opposite. Here the dock icons seem over-saturated. At first look, people immediately react and say their monitor calibration is off, even if it is perfectly fine.
2. Monitor white point changes suddenly
In some instances the white point of the monitor will change suddenly when photo or video editing applications are opened.
Many Macs have two graphic cards. One integrated that is active at boot time, and a more powerful discrete card that is used when a graphics heavy application is opened. I would guess this bug is related to the switching of the graphic cards. The visual effect indicates that a custom ICC profile for the monitor is used at first, but a default profile or LUT with a native white point is suddenly loaded when the OS switches to the second graphic card.
3. Adobe Acrobat X and XI soft proofing
This is the most serious issue. For some users the rendering to the screen can be different in the two latest Acrobat versions for Mac, compared to the other Adobe programs. Soft proofing a PDF in Acrobat X and XI seems to be off from Adobe Photoshop, and the older Acrobat 9. Acrobat X and XI show de-saturated images.
If you only use Acrobat for document control, the latest versions are fine, but if you do critical soft proofing of PDFs, I would recommend testing Acrobat 9 and X/XI against each other on your system before upgrading.
There are color bugs in Acrobat 9 on OS X 10.8, but most users will probably not encounter these. (A restart of Acrobat 9 after you have changed monitor ICC profile without rebooting the machine can cause the PDF to be rendered with the old profile, while the menus and UI elements in Acrobat are rendered with the new profile.)
I have not seen any information that identifies whether this is an Apple or Adobe problem, but I have only found this issue on Macs. On Windows, Acrobat 9, X and XI soft proofs consistently.
[2013-02-04 UPDATE: As a reader pointed out, the soft proof bug in Adobe Acrobat X and XI on Mac 10.8 has been identified by Adobe. It happens when you activate a custom monitor profile on your workstation. No date for a fix yet.]