I wouldn’t buy a computer with less than 16 GB RAM, but...
My previous MBP had 16 GiB, and the current one 32 GiB. I was almost certain the difference would be huge, but to be honest, I have not noticed any difference with my workloads. I handle some rather large datasets and occasionally edit videos in 4k.
I think part of the story is the very fast SSD we have nowadays. Of course, fast SSD is 2 GB/s, whereas fast RAM moves the decimal point by at least one digit. Still, unless your algorithms require random access to the data, many things including video editing are acceptably fast even with some of the data on the disk.
I have never had a computer with too much RAM. However, 16 GiB may actually be a bit more than it used to be a few years back. (YMMV, of course; a billion point FFT screams for 32 GiB RAM.)