Apps like a secure recent browser (even firefox ESR will end support soon) or the latest version of Noiseless Pro ... thinking ... MySQLWorkbench ... I know there have been more apps that I couldn't upgrade. Even though you still can do the most things in 10.8, but more apps will have demand for a recent OS and I'm not sure if there will be a community around for 10.8 at some day like for PPC.which apps are you talking about?
Do you know if the legacy version of Java just needs to be installed or actively in use. In other words: Will CS6 continue working if you switch to a recent Java version while the legacy version is installed?