Honestly they're all pretty much EXACTLY the same - if you're coming from a decent machine (like I consider your current computer). I recently got the 2023 Mac mini M2 Pro - been using for ~2 weeks for 12+ hours a day. It replaced a 2012 Mac mini (2.3ghz i7/16GB/aftermarket SSD), which I again was using for 12+ hours a day... I'm noticing absolutely not a single difference EXCEPT programs loading up much faster – in like 2-5 seconds, instead of like 8ish seconds for Photoshop or 25+ seconds for ones like Premiere Pro (which I rarely use anyway).
I thought the 2023 Mac mini, especially the higher-end M2 Pro model I got would absolutely blow me away... and for fun stuff like being able to click/open Adobe InDesign, Photoshop, Bridge, Lightroom Classic, Illustrator, Dreamweaver right after another and have them all magically open literally ~5 seconds later it DOES blow me away... that's cool as hell... but honestly, I don't use ALL of those at once (ok, many times I do, but not all the time), let alone launch all of them at once in a row anyway... so it really doesn't matter.
Switching from one program to another 500+ times a day is the same experience as my 2012 believe it or not... Loading files is exactly the same too since the real choke point is my Gigabit internet and the old gigabit-only server I connect to and store all my files on.
Doing stuff like advanced Photoshop filters can be WAY snappier... but again, even with my experience working for Fortune 100 companies that's not something I tend to do much (the nice Getty images we pay for don't need much). Even files I do have to go to town on, with like 30+ layers/layers within multiple folders... still seem to act the same for the most part
I even had a chance to do some super-mediocre video stuff on the 2023 Mac mini M2 Pro (a rarity for me, I'm mostly digital and print still), and thought the final video file output would take like 30 seconds since everybody is saying how blazing fast these are... nope, still took 4-6 minutes to output a SUPER simple video (literally took a 3-4 minute long 1080p60 vacation video I took, and needed to flip it 180º then mirror – then output to 1080p Vimeo format and it STILL took ~5 minutes to export). Sure, my ancient 2012 might have taken 15 minutes for all I know, but whatever, I still wasn't blown away on performance.
Now if you solely do video work, or other crazy intensive stuff... then you shouldn't/wouldn't be using a Mac mini anyway TBH - use a Mac Studio+ or whatever... for the normal user I think the benefits wouldn't even be noticed to the lesser degree I've outlined above as they're doing WAY more simple stuff.