FME deserves a mention, an ETL aimed at GIS data. It is the only automation tool I have ever used that doesn't make me want to switch to code. Everything can output to a node which makes it easier to understand errors. And every stage of processing can be inspected.