There is a fourth category that fits your description of charismatic people quite well IMO: psychopaths.
The distinction can be quite hard and might take some time.
The distinction can be quite hard and might take some time.
https://en.m.wikipedia.org/wiki/Psychopathy
"Psychopathy, sometimes considered synonymous with sociopathy, is traditionally defined as a personality disorder characterized by persistent antisocial behavior, impaired empathy and remorse, and bold, disinhibited, and egotistical traits."
Not quite sure how you got there from charisma.
I was actually looking for the term sociopath.