I was just thinking there of a field where men and women are more equalized, and that would be in music. There, where innately nimble fingers are at a premium, women do very well compared to men - there are tons of great lady pianists, for example.
I think that's the rationale behind the specialization in DEX for female fighters, and it does make some sense, but the trouble is that DEX is usually carried over to things like speed and reaction speed, where it's not necessarily so appropriate. Bracketing speed of neural reflexes (which as the above re. music) is probably more equal, in terms of shifting mass quickly (arm, body, etc.), you get greater speed the more muscle mass you have, so speed and strength are really closely tied together.
Also, bows require STR more than anything else, DEX is really not that involved, so that trope is out the window. Light crossbows, yes, that would require DEX to some extent (to change the bolt and rewind without fumbling in the heat of battle, provided the changing mechanism has good leverage).
Daggers, again, maybe there you could just about have the idea of a nimble, mobile female fighter, if you're talking about the upper outlier end of female strength, as with those rock-climbing chicks.
Guns, again, there it's probably more equal (cf. the famous couplet about guns equalizing things for women).
(But some of these problems are to do with the constrained and sometimes lumpy simulation/abstraction of D&D.)