I have current version of photoshop, so I can contribute a little from my part. Camera raw has an early access AI feature called "dust" under removal panel, it is supposed to find and clean it in one click, but it doesn't detect my dust at all. I have a suspicion it is trained on a dust from digital sensors, not scans.
Photoshop AI has one thing the others don't, it is the only AI tool I found, which fills only the selected portion of the image, so you can, for instance, fix a nasty light leak without affecting the rest of the image:
rb67 + portra 800
But take in mind the current versions of photoshop upload everything you put into it into their cloud to train AI, if you firewall it, then you loose the AI tools. Also, sometimes it fails, like here when I tried to remove the fence:
rb67 + portra 800
The only reason I see why to use the new photoshop nowadays is the AI denoise in LR, which let's me shoot on 25600 iso. Other than that it is quite useless, because you cannot rely on the AI retouching tools. If I didn't make a living from it, I doubt I would pay the expensive subscription.