Agreed. The notification has to be there.. So use it well.

White (as is current) if default profile is active
Muted Colour assigned (red, blue, green, purple) either automatically to each different profile or user selectable colour. (by muted i mean faded so as not to massively stand out)

It would be great to look at the screnn:

White oh im in defaults
Red im definitely at work, im certain the location detection is on, no need to worry about that ringtone!