Divine inspiration also deals with trust channels. If someone claims to be divinely inspired (which I personally believe is possible - see Buddhism Insight for example) then whoever they relate this information to will then have to implicitly trust the information coming to them is actually represented as the divine intended it (assuming they don't have direct access themselves). Obviously, that's caused a lot of problems in the past for us, so it's non-tenable. Teachers of the way[1] avoid dictating teachings received from insight because of this. It's also probably why sutras tend to be very terse, now I think about it.
The answer to your question is that it might be possible, but it's unlikely to be possible for long as the trust channels turn implicit, which then has an impact on the individual's relationship with their followers. When someone trusts you implicitly, there is no feedback on whether their trust is warranted or not, or put another way, there's no way for you to to trust if the trust you are receiving is real. And that is just as bad as you not being trustworthy.
Emma Goldman comes to mind, for me.
Is it possible to be both charismatic and not-narcissistic at all? I can't think of a single example, to be honest, of a leader displaying charisma and not being somewhat narcissistic.