Entity Relationship Diagrams

I love diagrams for designing, redesigning and documenting Drupal sites and training end users. Mostly I think about entity relationship -style diagrams and diagrams for workflows. What do you use diagrams for in Drupal? When not to use diagrams? What is the best software to draw Drupal-diagrams with? Can you automate it?