I’ve been experimenting with Google Maps hacks recently:

http://www.dynamite.co.uk/local/

The basic idea is to try to combine a lot of what other people have already done into a single app, and create a system that lets you overlay just about any data on the map.

Still needs a lot of work, but it’s getting there.