So I keep hearing… Yet, I’m having a hard time believing that most people are even aware of those fancy features, let alone use any of them.

I accept that there are important models implemented as excel sheets. Reimplementing or even attempting to migrate away is viewed as risk. But this is a different argument.