Iliah,
I have great respect for your intellect ... but who would ever want to have a scene-referred color-matched shot at night in Times Square? It may be an extreme example of mixed illuminants, but who cares?
When I shoot in a place like that, I worry about a pleasant image ... not color-matching a memory.
What's your point? Where is modern color-managed photographic workflow letting you down? I find the current crop of tools MORE than satisfactory - expecially when compared to the world of film and chemicals.