Great article, thanks!
I, as others have commented, were hoping that this new feature might be useful.
Unless I am missing something, if the server has sufficient memory, then the data tends to stay 'in-memory' anyway. And if the server has too little memory, than it is great that it can cache.
Personally, I like the idea that if the dB exceeds the memory, the system will not crash (unlike the 'in-memory' databases).
Going back to my early Computer Science days, all processes happen in memory, and this has not changed. So while overly simplifying the matter a bit, more memory is good.
Ok, so it sounds like the SQL Server dev team would have been better to find ways to optimize the existing stored procedures. And finding ways to fully compile the standard proc. And to tweek (optimize) the existing data structures that are already in memory (if it is really needed)
The more you are prepared, the less you need it.