Affinity Photo if you want a photoshop alternative that doesn’t come with a subscription attached.
Darktable if you want FOSS with organization capability. ( https://darktable.org )
GIMP for a poor man’s photoshop, good for simple edits.
Discussion
i don't think gimp is that poor of features but maybe the interface seems a bit more clunky, it can do almost all the things at least, of Photoshop CS (that's how long it's been since i used photoshop)
if this tooling now also means stupid AI generators then yeah good luck going without a subscription, them kilowatts gotta be paid for lel
There is a massive gap between the capabilities of the two, once you get past the simple edits. The same can be accomplished by hand in both, but it’ll take much longer and parts will have to be done by hand.
I’m not sure how much of it is AI assistance. Affinity is cheap enough and good enough I don’t deal with GIMP for anything complex.
I think darktable (which is FOSS) is more what he’s looking for since he’s using Lightroom.