(via http://www.chandima.net/Blog/archive/2009/01/13/sharepoint-is-on-the-intranet-top-ten-list-again.aspx)

http://www.useit.com/alertbox/intranet_design.html

Why are people saying that Sharepoint is not a good CMS, Intranet, web site or portal ?

http://blogs.msdn.com/carloshm/archive/2009/11/25/follow-seo-recommendations-in-your-public-sharepoint-deployment.aspx

http://www.andrewconnell.com/blog/archive/2009/10/19/part-1-improvements-to-the-core-sharepoint-platform.aspx

Sharepoint CMS functionality are contained in the Web Content Management (WCM) module (publishing template in MOSS), formerly existing as a separate product: Microsoft Content Management Server 2002 (MCMS).

Below a few posts about CMS functionality in Sharepoint 2007 - MOSS 2007 for Intranet, Extranet, Internet

http://www.cmswire.com/cms/web-cms/web-content-management-with-sharepoint-moss-2007-part-1-001994.php
http://www.andrewconnell.com/blog/articles/MossWcmResources.aspx
http://blogs.tamtam.nl/mart/MOSS2007WCMIssuesAccordingToOurCustomersNdashPartIII.aspx
http://blogs.msdn.com/arpans/archive/2006/08/02/686152.aspx
http://msdn.microsoft.com/en-us/office/bb251752.aspx

Web Content Management - CMS for an Intranet
http://www.slideshare.net/garethjmsaunders/sharepoint-intranet-cms

Free Sharepoint CMS runs on for Windows Sharepoint Services  - WSS

http://www.cmswire.com/cms/web-cms/no-moss-required-free-web-cms-built-on-sharepoint-services-004106.php