no he's definitely sick & insane. the fact that he is a "true believer" who is eager to use violence to achieve his ends, and who isn't afraid of death makes him someone to be fearful of.
Cersei is ridiculously stupid for arming a bunch of religious fanatics & extremists

she is obviously pretty terrible at ruling & shouldn't have power, but of course she believes otherwise.