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

Try a MI.
SoundSmith

Maybe give the Hana moving coils a try. They seemingly provide all you describe. Outstanding mc cartridges at great prices. I step up my Hana EL (with elliptical stylus and Alnico magnets) with a jensen mc 2RR-L transformer (1:10 ratio/20db gain/430 ohm load impedance) into a Tavish Design tube phono preamp, the sound is divine. Using three tubes, Ge jan 5751, Tungsram 12ax7, and a Ge 12au7. I got an RCA 7025/12ax7 and an Amperex bugle boy 12ax7 in reserve to try as well.

But as I mentioned 'goose-bumps' (goose-flesh in American English?) which is instantaneous, non-intellectual, having nothing to do with that deeper 'relating to the intellect' but more with some simple primordial (basic and fundamental) reaction!

This reaction can be caused by everything, often it's music itself (no matter what quality). If you can feel it only with MM cartridges as you said earlier then it's just you and not necessary anybody else on this forum. But if you're interested in MM cartridges (high quality performers) I recalled some of them. You can't go wrong with top Stanton and Pickering, those are emotionally rich cartridges with very sweet tone. 

If you like MM so much then continue with better MM or MI and you will find what you're looking for (in terms of sound). 

Chakster, I was of the understanding that you were a dyed in the wool moving magnet guy. Now it seems there are moving coils that you like also. Have you heard a current mode phono stage with a very low impedance cartridge yet?

@mijostyn I posted so many times about my current mode (current injection) phono stage (called 47 Labs Phono Cube) I like a lot with my MC cartridges.
I also posted how exactly I came to the best vintage MM after using modern expensive LOMC in $2-5k range. 
The only modern LOMC I have today is Miyajima Kansui, my Ikeda 9 III is a bit older, but my favorite LOMC are much older (FR-7fz, Miyabi Standard and Miyabi MCA ... ). All LOMC works perfectly with Gold Note PH-10 phono stage. 
One cartridge I use a lot these days is Fidelity-Research FR-7fz on FR-64s tonearm with B-60 vta base on my Luxman PD-444.


Current mode phono stage from 47 Labs is great!