If you are a SharePoint 2007 shop or thinking about becoming one check out
this article on how a Microsoft Partner called
Provoke built a custom metadata repository and surfaced it up through SharePoint. I see this method being a trend for enterprises as we start to mature in the practice of information architecture.