It's used exclusively derogatorily, as far as I've ever heard it. I use it all the time for some of the people I deal with, people who believe that they are somehow sanctified because of their creative talent.
I had a girlfriend once who was an artiste.
I'm really glad that sentence is in the past tense; let's just leave it at that.