In my opinion many ERD tools today cater to the intensive (concerned about physical and logical modeling) crowd, and therefore unless you have a large organization who has the specialists, you do not see the diagrams. I have pushed ERDs at all the places I have consulted. However, I am not the intensive type, so stick to physical). A relatively inexpensive tool I have found and like is "ModelRight".