Is macOS Sierra currently bug-free and stable to run Adobe programs?
No, it is not bug free.  The question is whether its bugs matter for your particular needs.  To find that out, clone you current system to another partition, upgrade that to Sierra, and verify that the apps and external devices you require for your work all operate the way you need them too.