I would like to kindly update my activity concerning the latest version of OS Sierra (Nov 5, 2016). I decided to give it a try, so I upgraded (with my fingers crossed). I am using a Macbook Pro laptop, mid-2012, 13" model. I am using a 500gb sata hdd with 16gb ram. the vid card is the intel 4000 proprietary.
As a side note, I upgraded while having 100gb free on my HDD and no open apps running. I completed the upgrade successfully from start to finish. So far, all apps are working without issue.
Apple Mail app works.
Maya 2016 works.
Photoshop CC 2015 works
Lightroom 5 works
Illustrator CC 2015 works
Aftereffects CS6 works
Premiere Pro CS6 works
Word 2016 works.
Day One works.
The above apps are the most important to me at this time concerning my day to day workflow. I've got more apps on my system, so I will check back if any apps on my system have any trouble(s). I have not had to use SIRI for anything as of yet. I am not going to call it useless, but for my workflow, it is not useful...Which is fine. The main reason I wanted to upgrade was for Pages 5 app, which is working great.
One thing about photoshop is zoom-scrolling with the middle mouse wheel seems jumpy/glitchy. The zoom is way too dramatic and not smooth like it used to be with EL CAPITAN. Hopefully, that issue will be addressed and fixed soon. It's not much of a problem switching to the zoom tool - takes an extra 5 seconds or so but that's no prob, I'm versatile.

It would still be nice if I could use the mouse wheel like I used too....It's much easier and faster, of course, but I digress.
So all in all, everything on my system including the wifi - works well. No issues at this time. My only gripe is the performance seems somewhat
slower than El Capitan in various scenarios. I know some people will disagree, but this is what I am experiencing on my specific system, which I why I outlined the hardware specs for my system before typing anything else in this post.
I hope the next update speeds things up a bit overall!