This is as difficult as I imagined.

HashPhotos has some of the functionality, can deal with the tagging and editing.

There are various metadata editors out there, but none quite as basic and automated as I am looking for. Nothing has the kind of automated library “editing assistant” i.e. leads the user though their library in the tidying exercise.

Maybe I’m just discussing around what is basically Apple Photos, which is annoyingly not available in any meaningful way on PC.