What is it in MM that can give me goose-bumps? 🤔

Stanton CS-100 WOS and Pickering XSV-5000 can do that. Both are oustanding MM, very rich and sweet sound. 

Dynamics. Absolutely. If you are a rock fan than a fixed coil cartridge is the only way to go. MCs as a group are too polite. Some of the ultra low impedance MCs with current mode phono stages might be a match. But , way more expensive. I have not had the pleasure of hearing this set up yet. The other problem in the cartridge world is that MC cartridges are frightfully over priced. Thank you Koetsu which started this trend in the late 70s.

Dynamics... is it *just* this? 

I hear differences in timbre/tonality of practically all that's going on.

My Quintet Black and Cadenza Black sound good, but there's always something sort of 'engineered' about the sound, and even other items like PW Windfeld or its predecessor... whether using an SUT or straight into 100-200 ohm loading, this MC charcteristic remains. 

As for CD, when comparing identical recordings to LP running an MC, it sounds so very much the same, good, practically indistinguishable - but just like ultra high tech engineered. Best I can put it. 

Like a bit say the difference between a mechanical piano (perfect) and one played by a person, both perfect - yet one more filled with life, the other somehow a bit - sterile? 🤔 

All this can't be said when I'm using any of my MM cartridges, and it has more to do with timbre and TIMING... , than higher/better resolution. 
Michélle 🇿🇦