A client of mine publishes several magazines.  The websites for these are published in Drupal.  Production uses InDesign to create the files that go to print.  My job?  To improve the workflow.
Currently, content is written in Word, then imported as plain text, and formatted via a series of keyboard shortcuts.  Changes are made, sometimes in InDesign, sometimes in Word, and eventually sent to print.  To publish on the web, the content is copied from InDesign and re-formatted to fit the online template in Drupal.
Here is what I am going to do:

1. Create a template file in InDesign where all the styles are named with XML friendly names and the content areas are all tagged with appropriate tags.
2. Create a View in Drupal that exports all content selected for that InDesign file as an InDesign friendly XML format.

That is the basic concept.  I am not using any out of the ordinary modules to do this.  Just Views, tpl.php files, and a bit of PHP.  I will try to post the details soon... Would be interested in any experiences others have had with a similar process!