I wouldn't say I'm very hard on hubs, being about 72-76kg in the summer and mostly ride in fair weather, so maybe I can get away with more than others. I do however squat between 140-185kg depending on how much I hit the gym so got a bit of power at least to put down (I know, who cares about squats but I ain't got no powermeter haha).
Over the years I've been riding several sets of DT 240/180s, old DT pawl hubs, Bontrager pawl hubs, Tune King/Kongs, Syncros with DT internals, Sram front hubs and now Extralite HyperBoost2.
Broke a DT pawl hub and I've had slips with every other pawl hub including the Tune even though they've all held up. One Tune King front hub developed bearing play quite soon.
Never ever had a slip with DT star ratchet hubs or with the HyperBoost, no trouble with bearings on the DT's and so far so good on the Extralites. And no wear to worry about yet on the Extralite freehub/hubshell.
So this has made me prefer ratchet style hubs and even though I know that many pawl style hubs are really good I'm still hesitant about getting them.
Of course the freewheel system on the Extralite isn't as bombproof as DT when it comes to wear, but one good thing with the current updated version of the Hyperhubs is that if you would however mess up (as in riding tons in bad weather and neglecting service) and notice that the system has been worn you "only" need a new freehub and ratchet and have another chance. On the first version, if you wore them out the hubshell was bust too but now you have two ways of fitting the star ratchet so if one gets worn out you just switch position in the hubshell when installing a new one.
Like I said, I don't usually destroy or wear out hubs and I don't see too many highend hubs in the shop I work at so maybe I'm not the best source of info - still just wanted to share my experience.
A friend is soon getting Carbon-Ti hubs though, and I certainly won't try to stop him because they do most definitely look nice too.