Interesting analogy. With ballistics, it's more velocity to weight.
Seems to vary with the caliber. In .357 Magnum, in the anti-personnel context as opposed to hunting, "light and fast" proved itself in the '70s and '80s: a 125 grain bullet at 1450 fps.
In the 9mm, the 124-127 grain at 1250 fps that's my current favorite is seen today as a medium weight range, but would have been "heavy for caliber" a quarter century ago. Until the coming of the "super-heavy" 147 grain subsonic in the late 1980s, for most of the 9mm Parabellum's history, 124 grain was the heaviest bullet weight you could buy in a loaded cartridge.
In .45 ACP, John Browning had originally conceptualized a 200 grain bullet, but the military wanted heavier so 230 grain became standard weight. Today, though there are certainly good, proven 185 and 200 grain bullets in the caliber, 230 grain are the most popular and the most street proven, so "heavy for caliber" seems to be the leader in this example.
The rounds that get used and issued the most are the ones that become the most "researchable" and the most "street proven." Those are the ones by the biggest makers: Federal, Remington, Speer, Winchester.
Hoping that's helpful,