It sounds as if you've decided already.
By your standards, I would say most handgun rounds are ineffective.
I personally would prefer not to have that energy dumped in me once, let alone a few times.
I think the .380 is an effective round, but slowly becoming obsolete due to the size of the current 9mm models.
Because of the metric system?