Ak,
There is a custom workflow activity that Simon Hutson created that allows users to generate new sites based off a site template in SharePoint from a CRM event (like Status Change of an Opportunity which you had stated above).
You could also modify the custom workflow activity in Visual Studio to do even more, like post-create edit the internal information on each page, or set a username and password based off contact information, etc.
Paul Reitmeyer
http://www.mscrmdirectory.com