“M” Modeling Tool (and language)

I guess I was expecting “modeling”, not a metadata and data viewer.  For the last 2 I can easily use at least 4 other tools (SSMS, Excel, Visio, and Word).  What I was expecting was something similar to Data Diagrams feature that was available since SQL Server 7.0 (if I am not mistaken), or at least since SQL2K for sure, but with some “Erwin/Embarcadero”-type enhancements, that allow you to design a database, and then deploy it by generating a deployment script.  I guess there are a lot of missing steps that I overlooked, not only while using it, but also while reviewing the accompanying documentation (http://msdn.microsoft.com/en-us/library/dd857506(VS.85).aspx).  What frustrates the most is the ease of installation (.NET Framework 4.0 beta is the only pre-requisite - http://www.microsoft.com/downloads/details.aspx?FamilyId=AB99342F-5D1A-413D-8319-81DA479AB0D7&displaylang=en), and uselessness of the documentation (as it’s so very often the case with Microsoft).

So where do I go from here?  Well, back to Database Diagrams, since they’ve proven to be a very nice (considering the price=0 with the Developer edition) and long-lasting in terms of results tool that many DBA’s and database developers have used since 1999.