This is one of the more visually interesting Google Maps mashups I've seen:
OnionMap, a sort of tourist guide map (to popular tourist cities only), highlighting points of interest based on category. They don't appear to be very far along, but you definitely get the idea from what they have so far.