Also, what role did the strategic culture of House Atreides play in how they ruled Arrakis, if at all? Or were the events simply the ultimate demonstration of "Great Man Theory"?
They didn't, House Atreides was all but wiped out within month of their arrival on Arrakis.
It was only because of utterly incompetence Harkonnen-Imperial counter-insurgency strategy that led to the unification of the Fremen tribes under Maud'bib and the formation of the Mahdiphate.