I think this myth has arisen due to the fact/theory (take your pick ) that how we remember a scene is actually different to how it really was if measured photometrically.
It is a fact that at lower light levels, the (colour) cone sensors in the eye are less senstive to light compared to the monochromatic rod sensor. Thus in twilight, or moon light, we largely 'see' in monochrome (except the brain doesn't know that) because any bright light, like an orange sodium vapour lamp WILL trigger the cones and we do see it in colour.
The crux of this matter is that we walk away remembering a low saturation scene, then, when we see the photographs at standard viewing luminosity, the (more) faithfully recorded actual saturation levels appear greater than our memorised ones, thus we could, erroneously (IMHO) 'explain' this as it being the longer shutter speed gave us more saturation.
I am only considering shutter speeds in the range of 1/10s to seconds here; not Colin's habit of exposing several minutes in (naked eye) pitch black and coming back with a fabulous 'sunset' picture - because that's obvious to him, but it is the same thing really. Not withstanding Colin will PP his shots and may boost saturation, unless you knew, anyone that wasn't there at the time would just assume he had shot it earlier in the evening when we see colours in the sky like that ourselves occasionally (while they are still bright).
That's my pet theory, YMMV.
Cheers,