Newspapers in particular seem to have embraced Fusion Tables as the data backend for Google Maps.
In the UK The Guardian seems very keen on Fusion Tables, especially on its Data Blog. The Guardian's Data Blog is a great source for data and the paper itself often creates Google Maps of the data.
A good example is this Google Map showing the carbon emissions for public buildings in England and Wales. The energy performance of more than 40,000 schools, hospitals and government departments are shown on the map.
The Carbon Footprint of Public Sector Buildings
In the USA The LA Times and The Texas Tribune have both used Fusion Tables to create maps to report on the 2010 Census.
The LA Times has produced a Google Map to show the 2010 census counts by California’s congressional districts. The map shows how many residents the 53 congressional districts are above or below the target 702,905 population.
2010 Census Counts by California’s Congressional Districts
The Texas Tribune, on the other hand, has created this Google Map to visualise the Texas population by race and Hispanic origin. The map displays the totals for each district, with darker colours representing higher rates of total population growth by race or Hispanic origin.
Texas Population By Race, Hispanic Origin