I wrote some scripts a few years ago to do just that. I haven’t used them myself in a while, but they should still be good.

https://github.com/jonathankoren/photo-autorganize