I like mid-weight, fast, bullets personally, at least in 9mm. I do think energy is a factor.
That said, pistol bullets at these velocities simply do not create damage from the temporary cavity. Only tissue that is physically touched by the bullet is permanently damaged. .357 Sig consistently produces the most impressive permanent cavities, especially in overall length of the large permanent cavity (typically around 7 inches).
This is a good read: