I used Dataedo to document a project in which we had used some over-seas development. Not only it was helpful in creating documentation, but it proved essential when it came time to bug fix and troubleshoot. The fact it enabled us to update and provide consistent documentation paid for itself. Thanks to Dataedo I spent more time figuring out the connection string to the instance than I did running the report. It was a great experience. I'm continuing to use it with no expectation of stopping anytime soon.
We use Dataedo for documenting the database of our main software. It's a central reference for the developers and the analysts and we share Data Dictionary with third parties who develop BI system. What I like about it is that it's easy to find out what's not documented and a well-done Data-Dictionary in PDF. I would definitely recommend it to others.
I used SQLDoc3 before, but now I am using Dataedo, and it is a great tool for me. Most of the time, we design the database schema directly via database tool, and we needed a mature software to help us generate the database schema document for it as well. Dataedo is easy to understand, and we are using it on regular daily basis. We would for sure recommend this software.