David Hricik and Chase Scott have published a thorough piece on where most common software creates metadata, available here in the February 2008 Georgia Bar Journal.