Thank you, I was worried that in the future programs may be more dependant on ram and fearful about the fact it cannot be upgraded, like on previous machines.
I am very confident that this will not happen. Just as with CPU speed, the question about RAM is the question about now, not future. Does your work need this NOW or can see a possibility of doing such work in near future. Grabbing "better" spec to future proof the machine doesn't make any sense, just like it won't make any sense to buy a fast sports car if all the driving you do is in a contested town.
What follows is a detailed explanation to why I don't believe that we will see substantial increase in basic demand for RAM over the next few years.
Lets look at why average RAM requirements increase over time? Generally, there are two following factors: asset size on one hand (images etc. the apps use), and programming techniques, frameworks and patterns on the other (more abstract, sophisticated programming tools usually come at a performance and memory cost).
We have just experienced a big jump in asset size few years ago, where the entire industry went to HiDPI (retina) content. This has increased the asset size by the factor of 4. And it probably won't increase much in the coming years since the resolution won't see any substantial increases. One thing where an increase is possible is color depth — as we start getting into wide gamut displays etc., we will probably see gradual transition to image content with more color information /HDR (I predict around 5+ years before this becomes even remotely commonplace). But even then the average size of images won't increase much, since we will still be using 32bit pixels, just packed differently (like 10 bit color components or 9 bit components with shared floating point exponent).
As far as programming techniques go, we already are as abstract and sophisticated as it gets. The trend in modern programming is actually going BACKWARDS — towards more efficient programs. This is in part motivated by the fact that semiconductor industry has stagnated and the performance increase isn't nearly what it used to be just a decade ago. For example, apps that are built with Swift will also use less RAM. Other modern programming languages (such as Rust) are looking into this as well. Another factor is AI which is becoming increasingly prevalent in contemporary technology. To be honest though, I don't see any crazy increases in RAM demand here, the demand is more for specialised processing power. These applications will be dominated by GPUs and specialised AI coprocessors.
And finally — something that people usually miss — increase in RAM capacity does not come with nearly as high increase in RAM speed. So with DDR4 we can double the capacity of the RAM at the same space, but we didn't double its speed. In fact, the speed has barely changed. More RAM cannot become a basic requirement if the hardware is not able to utilise it efficiently. It will take almost 2 seconds (!!!) for your CPU to scan through all of the RAM. That is an eternity for the CPU if you consider that it can add-multiply over a trillion numbers in that time (just to make the relation clear, you'd need 3725.29GB of RAM to store that many numbers

). And we don't have any technology to break through that yet... new approaches attempt to widen the memory interface (such as the 1024 HBM2 memory used at the new Vega GPU), but that relies on the same old "slow" RAM, just a lot of transfers at the same time, which doesn't help the CPU (that needs new data in small chunks but needs it NOW). All in all, large amounts of RAM will have the same utility as they have now — to support working with large datasets (an example given here was editing huge RAW images in PS using a lot of layers).
The current status quo might — and will — change in the future. In few years, hopefully, we will have CPUs with 512bit vector units and we will have GPUs that are very fast and increasingly important for basic applications. We might get multi-channel RAM as standard feature. We will also get larger CPU caches and more cores. All this has the potential to drive up the RAM requirements even for basic software, as it starts adopting all these new features. But before that happens, your 32GB Coffee Lake will be a hopelessly outdated dinosaur anyway, it won't support any of the new features the future software will rely on.