I think it is worth mentioning that both Apex SQLDoc and Innovasys DocumentX use special (and virtually identical) comment tags so that they can suck out the comments and build a compiled help file of your database.

These two products are inexpensive.

Because of what they do the benefit to the individual developer of commenting their code becomes very obvious. The larger the project the more important the comments become.