If our computers never got faster, we would never get faster computers (obviously...) to run efficient code even faster. 3D rendering and physics simulation come to mind.
I have noticed what you mention over longer timescales (e.g. a decade). But it's mostly "flashy" software - games, trendy things... Which also includes many websites sadly - the minimum RAM usage for a mainstream website tab these days seems to be around 200MB.
Anecdata: My 12 year old desktop still runs Ubuntu+latest Firefox fine (granted, it probably wouldn't be happy with Windows, and laptops are generally weaker). Counter-anecdata: A friend's Mac Pro from many years ago can't run latest Safari and many other apps, so is quite useless.