Anyone know if this allows recent-ish versions of Lightroom Classic to work?

Not much. Mint generally works very well. It’s not bleeding-edge fresh and is based on Ubuntu. I don’t think it would cause you to be unable to do any of your use cases any more than any other Linux distro - like the kernel level anti-cheat thing for games, or Adobe Creative Suite products. Doesn’t matter which distro you run, those things ain’t gonna work.

I was the same as many others here, started my journey on Mint. I eventually moved to Fedora because I like KDE and wanted quicker package updates and stuff.