I'm a UX designer. I use apps like Illustrator, Sketch, Figma, etc.
I don't think that anybody can give you useful advice without knowing how much RAM you use now and what you're doing with those programmes; and even then the advice isn't much use unless it's coming from other users of those apps.
To take the example of a programme that I know something about... If somebody says "I make music and I want to use Logic Pro X, how much memory do I need?", it's impossible to answer the question without knowing what the person is doing with Logic. Depending on what they're doing, the answer, including for professional use, may be 16GB, 32GB, 64GB or 128GB. There are also cases where some adjustments in the programme can affect whether one actually
needs 32GB or 64GB, of particular interest to people who don't have money to burn.
The other issue is how much you care about so-called "future proofing". Do you want the computer to last 3 years or 5 years or 7 years? Personally, I'm a skeptic when it comes to future proofing, but my Max is replacing a computer that was purchased less than four years ago.
I
do think that some people who have purchased, or are talking about purchasing, a Mac Studio are engaging in some extraordinary RAM inflation. All of a sudden, I'm seeing claims that one needs 64GB of RAM to use Photoshop/Lightroom or Capture One, which for the vast majority of people is complete rubbish. The fact is, most people don't need 32GB of RAM for those apps. As far as I can tell, what's happening is that some people have decided, because Mac Studios come with 32GB of memory and up, that 32GB is now a minimum. It helps them justify their purchase to themselves.
You might find it useful to look at YouTube videos that test M1 Max computers (14" and 16" MacBooks and the Mac Studio), and indeed M1 Pro computers, with the actual apps that you're using.