Its nice to see someone else who seems to worry about their car as much as I do, everytime it does something different I wonder if theres something wrong with it!
Often happens when you stop a car as the heat soaks out of the engine and once stopped moving there is no air movement through the rad, so the fan cuts in, in an instant.
One of the reasons that if you take a spirited drive you should cool it down over the last mile or two.
Cheers for the replies guys,i understand the idea, im just surprised it came on with me not standing in traffic-my e46 never did,but i did have the air con on.