This sort of automagic refactoring/editing wizardry is also easier to pull off in a statically typed language like C++.
The Community Edition has 99% of what you probably would want to do anyway, looking at this comparison: https://visualstudio.microsoft.com/vs/compare/
Python’s flickrapi is pretty good. I trimmed my flickr photos down to 1000 using my own criteria rather than SmugMug’s most-recent hammer. It wasn’t so much a script as an interactive python session.