I personally never found him charismatic at all, even before all of this got exposed. He has always seemed like a tweaker who thought himself smarter than he is, which is exactly what he turned out to be.
I honestly struggle to understand how anyone would listen to him for any length of time.