What is “best experience” though? It’s such a subjective thing. For you it might be pushing a lever back and forth. For every one person like you, I bet there are hundreds who’d rather leave that menial task to the car. Manual transmission can quickly stop being “fun and engaging” and become a chore, especially if you drive through traffic regularly.

I, or rather my left leg, personally do not consider manual transmission as a good experience at all. I also think paying much less for fuel is also a very good experience for my wallet. Though of course I don’t drive a Lamborghini or even a nice M4, so there’s that.