This page is a visualisation of part of my Google Latitude history.
A few bits that are worth a look:
Control the size of the blobs on the map
Alter how much time you need to spend somewhere for it to change colour
Want your own heatmap?
Visit here to find out how to generate one of these heatmaps