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!