I would suggest looking at
- Mac minis with M4 Pro chips
- Mac Studios with M4 Max chips
Since you'll be using the machine to run Lightroom Classic, Photoshop, and some video editing programs (DaVinci Resolve Studio, Adobe Premiere Pro), don't skimp on RAM.
The Max chip has more hardware video encoding and decoding engines than the Pro chip – which might be a point in the Mac Studio's favor if you are doing a lot of video work and the applications that you are planning on using are able to take advantage of the hardware video engines.
The Max chip also has a stronger GPU, but it's not clear if you'd need it for your Lightroom Classic and Photoshop work.
In the M2 days, the high end of the Mac mini line (M2 Pro) blended into the low end of the Mac Studio line (M2 Max) – and there came a point where, if you loaded up a Mac mini enough, it made sense to get a Mac Studio. I have not looked at the pricing of the M4 Pro Minis and M4 Max Studios in detail, but the same may be true there.