There are many CMS software packages out there. The two new big ones are Drupal and Joomla. In my brief reading, it seems that Joomla would be my preference for ease of use and features. Perhaps this would be a nice platform for churches to build their sites.

Other notables are WordPress, Expression Engine, and Movable Type.