I'd like to see a slow-mo shot of a bad hitting a ball in the 'sweet spot' and not in the sweet spot, to see how they differ.

I assume that when not hit in the sweet spot a lot of the energy gets transformed into vibrations in the bat. Those vibrations then hurt your wrist/arm because flesh absorbs ~100 Hz vibrations far more than wood does.