Right now I'm running a suite of tests in Adobe Lightroom 12.1; in general the results are about in line with what you would except based on Apple's claims and the bump in core count and core frequency. Across the board the performance bump ranges from 9% to 37% depending on the tasks and how much they use all of the cores, both CPU and GPU.
In actual usage, it basically feels the same; maybe a tiny bit snappier when browsing the library in Lightroom. That's also what I expected. I didn't buy this expecting a bump in performance; I needed an additional laptop and the M1 Max is going to be used by someone else. I'd suggest that if you've held off on getting Apple Silicon then go for it on this one; if you have an existing M1 Max and really need more performance then the Studio Ultra is the best choice.
Obviously if you want hard-core GPU performance than a MacPro remains the best choice by far, or just use a PC with an Nvidia card (we have both at work right now and the PC as annoying as it is to use is ideal for 3D rendering with the top of the line Nvidia cards).