Microsoft Office SharePoint Server 2007 and SharePoint 2010 provides document management, records management and web content management capabilities. This means that with SharePoint you can create intranets, extranets and public facing web sites.
If you are looking for some great examples of public facing websites built on SharePoint check out the Silverlight live pivot demo at: http://www.wssdemo.com/livepivot/. This Silverlight pivot display has over 2,000 public facing web sites that you can sort and filter through by country, industry, and platform.
Building out very attractive SharePoint internet sites is not only possible but also uses the same skill sets that your existing .NET web developers and designers already have.
If you work for a state or local government agency in the North-Central region of the U.S. and would like to have a discussion regarding public facing SharePoint sites please contact me!