Dan Karran has been working on making a Geospatial Content Management System (GeoCMS) using Drupal and using the existing location modules which adds location information to any node. Additionally, he's written GeoRSS and KML modules, that allow for consuming and publishing these geospatial feeds. In Drupal, everything is a node. So when consuming feeds, new nodes can be created for locations that are consumed. Then information, links to other nodes, and various other metadata can be associated to this node, and it is then aggregated back out for other services to consume, display, and reaggregate.
This work is a perfect example of the point of my talk at FOSS4G, Enabling Users to Produce Personalized Geodata. It's more important for developers to add geographic capabilities to existing, and widely used tools than to make geo-specific tools and expect users to come and use them. People are already using Drupal for their content, and now they can easily add location data and share it with their users and consume feeds.
Check out his GeoRSS and KML Drupal announcement here.