The economic point stands that you aren't going to get a processor with only cache and no RAM because virtually no workloads want such an unbalanced system.
As SSDs get faster and L3 caches get larger, will conventional RAM get squeezed out? I know Optane failed a few years back, but that kind of convergence seems inevitable in the long term.