Another vote for photools.com and IMatch. Not only does it have scripting, it also supports XML import/export of metadata, plus a configurable database where you can fine-tune the metadata you want for each photo. It's a stunning piece of work for $60. I wish it ran on Linux.