Which spoke considerations are more about the best balance of factors, rather than a given spoke design being flat out better.

Factors to consider are weight, strength (weight capacity), rigidity, life expectancy, and good match to the rim's strength.

Thicker spokes will increase strength, and rigidity, but at a cost in weight and depending the rim, life expectancy of the wheel.
Lighter DB spokes save weight, can provide for more life expectancy by stressing the rim less, but will always build a less rigid wheel.
Any butted spoke will reduce breakage at the elbow, with the benefit increasing with greater difference. As a general rule, you want an increase of diameter of10-15%.

Good wheel builders aren't married to one favorite spoke, but will select spokes based on purpose, number of spokes, rider weight, the specific rim, and the rider's history of wheel problems. Many, including myself, will use two different spokes in the same wheel, ie. reducing gauge on the left side to compensate for the lower max tension on that side.

IMO, the goal is to build the lightest best riding wheel that holds up.