Pretty much everyone will benefit from the faster CPU single cores speed of the M2 Pro, so many tasks on your computer are single core focused.
At the end of the day, the people who need the extra GPU cores, know they need it. Regular workloads dont. So if you are buying an intel machine before, and it was important for your apps to have the fastest GPU you could, its still important now (unless you were just getting it to game in windows via bootcamp).
So as I see it for most people the Mac Mini with M2 Pro is best suited for the average to power user. It'll be faster in most day to day tasks, and stay current longer. It'll do great at video editing, photo editing, etc. I.e. its a beefed up mac mini, probably a good replacement for any one who had a reasonably specced imac 27 before.
The Mac Studio base level Max is perhaps better for someone who is doing a lot of video work (double the hardware video encoders), 3d work, and some other scientific/simulation fields which more headily rely on GPU raw power. And i mean regularly doing one or multiple of these tasks because its not like you cant do these as a hobbist with a reasonable experience on the m2 pro. Studio also has better IO, higher memory bandwidth. However, most people in this category should probably hold off for Studio m2 Max, unless they live outside the US and are expecting a big exchange rate hit on the new pricing.
Ultimately, both the top Mac Mini M2 Pro and Mac Studio base m1 Max are great machines, and while they suit slightly different tasks better, both will be fine for most people considering them. If you still cant decide I would say the mac mini is for you. The base studio should be your choice if you want a non-base studio (i.e. damn i really need 64gb, or 30+gpu cores for my work but I cant quite afford it) then the base studio is likely better suited to your tasks.
Also the fear mongering on here(generally not just this thread) is insane. 32gb is more than sufficient for most people including power users and people who want to keep it 10 years. Most computers today are still sold with 8gbs. Ram capacity hasnt really increased at a rapid rate the way its used to and people are stuck in an old mindset about it. The focus advancement has been in ram speed, which has been more important than capacity for most home users for a long time. If you cant point to a specific high memory professional task that you do or are very likely to do, then you dont need more than 32gb of ram (and 16gb is likely fine, but I can see the justification for 32 given its shared with the GPU).
Given the low price difference between the top mac mini m2 pro and base mac studio m1 max, it's also completely valid to decide based on form factor, and ports.
Most importantly, I doubt the people worrying about this would notice any performance difference unless bench marking both machines side by side.
IF you some how still dont know what you should get. Then work out your top 10 most common uses for your machine and see how those tasks compare in the head to heads you'll see all over youtube any day now.