For everyone in design related jobs that are wondering if Adobe CS6 still works on Sierra - I can confirm that Yes it does! I installed Sierra on a USB3 Memory Stick then did a fresh install of CS6 as a test. Note: I only use 'Design Standard' - Indesign, Illustrator and Photoshop - so I don't know about any of the other CS6 stuff, sorry. The only issue I had was with Illustrator (as before with El Cap.) you just need to install Apples legacy Java 6 first and then I'd recommend you install Java 8 to get the security updates or perhaps you could try the empty folders trick (Google it) if you prefer, I've not tested that method though and it might be tricky due to Sierras stronger security lockdowns.
Because my new install worked - my guess is that if you just updated your current OS to Sierra you'd have no issues with CS6 working, although you'd still probably need to do the Java shuffle as I imagine that Sierra will remove your existing installs due to them being seen as not compatible. Apple no longer supports Java 6.
I'll try to do this in a few days and update this post, once I check that all my other 'essential' software is working with Sierra.