Is macOS Sierra currently bug-free and stable to run Adobe programs? I'm thinking about updating to macOS Sierra, but I'm worried if there are still any bugs. Has anyone used it yet?
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.