Tim Inman, who won honorable mention in the Force.com Sites Developer Challenge, put together a nice write-up and video on why and how he developed a basic content management system with Force.com Sites technology.  He shares a few good lessons learned as well.

Click here to check out his blog post.  Hope to see more good stuff like this!