Hussar
Legend
Not sure what edition or rule you're reading that has Int give a bonus to weapon use. That you note 2-weapon fighting as a proficiency suggests 2e, as that's not a thing in 1e.
Also, weapon specialization (as opposed to simple proficiency) in Unearthed Arcana is broken as written, a common issue in that book.
Some common patterns do emerge, sure; but that would be the case in the game world as well as warriors talked over what worked best and what didn't and came to some general consensuses. Even so, someone could still choose to be an outlier and, due to background or whatever, decide to specialize in harpoon or something.
Except that you’ll find fifteen magic longswords LONG before you find a magic harpoon. So everyone uses a longsword.
Cookie cutter characters because certain weapons are flat out better than others.