So Before the Storm suggests that holding Azerite / being in close proximity to it makes you smarter. Yet only Sylvanas and Anduin ever note getting this spike in intelligence from Azerite and beyond the initial visions that they get neither of them really become noticeably smart. Sylvanas' plan falls apart because Saurfang refuses to kill Malfurion even though she should have foreseen that possibility, Azerite or not. Anduin's plan for peace falls apart even though he should have foreseen Calia's stunt at Arathi, Azerite or not.
Other characters seem to not be affected by Azerite at all. Neither the Blood Trolls, nor the Ashvane Company, the Mogu, the Heartsbane Coven or Zul's forces gain any power from it even though all of them seek to collect it. Actually Zul should've used Azerite to juice up G'huun but he didn't seem overly interested in it even though he was supposedly the smartest man on Zandalar.
In other cases Azerite seems to boost one's physical prowess. Earth elementals become enhanced by Azerite but at the cost of their minds. Other elementals seem to be completely unaffected by Azerite as seen in island expeditions. Then you have Therazane's forces try to collect it in the Crucible of Flame questchain and they don't lose their minds even though they are earth elementals.
Animals seem to either go crazy (Island Expeditions) or become depressed (Fey Dragons in Mount Hyjal) upon interacting with Azerite. So does Azerite improve your intelligence or does it make you go crazy? Do Fey Dragons become depressed because Azerite makes them self-aware and they realize the abject horror of their existence?
Some factions also try to use Azerite as a weapon or fuel for war machines but they don't seem to be more powerful or efficient than standards weapons or standard fuel. In all uses of Azerite war machines they got overpowered by conventional weapons and scored a grand total of 0 kills.
Is Azerite supposed to be social commentary about oil? Come to think of it, it's always found offshore (Island Expeditions, Nazj'vel, Seething Shore) or exotic foreign locations (Zandalar, Kul Tiras, Silithus). Is there any reason it only seems to pop up on islands, mountains and caves but nowhere else?
It seems like Azerite is just the cheapest and most abundant source of power / fuel available but it's not particularly more powerful or efficient than other sources of power / fuel. Its effects on intelligence are also questionable at best. So why exactly is it special? Am I missing something? What does it do?