Does anyone out there have any thoughts on database modelling/case tools?

My organization is looking for a tool to diagram the tables in our data warehouse. Once we got started, we'd probably use for other systems. We want to be able to show the relationships between tables and thoroughly describe the fields.

We've thought about tools like ERWIN, Rational Rose, UML, the Visual FoxPro 6.0 modelling wizards, Visio, and we're still thinking.

Who likes what out there? Thanks!