Asisreo
Patron Badass
I'm not necessarily trying to say that every action must be calculated before being able to use it. But with our mathematical model, we can find trends that allow us to make general judgements that we do not have to even think about.Sure. But how does a player know the goblin's hit points? If the target is instead a goblin or kobold with 4 hp, then the crossbow is better because with 1d8+1 only 1/4 of rolls are below 4, whereas with 1d10 3/10 of rolls are below 4.
In any event I don't think @Blue was thinking of fights against goblins. The point was that in fights at mid- and upper levels, the players (via their PCs) defeat monsters by piling on the results of multiple damage dice rolls (from multiple attacks, spells etc) at which point there is a general trend away from extreme results and towards mean-ish ones. At which point the practical difference between (say) 1d10 and 1d8+1 tends to reduce.
Leaving aside the playtime overhead of doing this sort of calculation, there is a mechanical overhead also - eg your wizard switching from spellcasting (with a focus?) to a crossbow has to engage the "changing held/wielded object" rules, which in turn impact the action economy.
My feeling is that for this sort of thing to be worthwhile the optimisation benefits have to be bigger and more obvious. Eg in my long-running 4e game the fighter would switch between a really big axe (good damage) and a not-quite-as-buff polearm (lesser damage, but superb reach). The player also took proactive steps in making build choices in order to manage the action economy implications of changing his weapon from round to round or even sometimes within a round.
We can understand that smaller but more numerous dice has a lower variance than larger but fewer dice. This means when comparing two attacks of similar damage, you'll want small dice for low-HP monsters and large dice for high-HP monsters.
So choosing whether to cast a 5th-level fireball versus a Cone of Cold comes down to whether the minions are generally strong or weak. If the minions are weak enough to die from a single fighter's hit, it's safe to say that Fireball is the correct choice. But if they take 3 or more hits, we can understand Cone of Cold is more reliable to kill, even if we don't actually have exact numbers.