I've found that the brand and type of film makes quite a bit of difference as to how the various urban lights are rendered.
In particular, it seems that Fuji (Superia 400, 800, and even 1600) films are far more tolerant of the various light sources.
This image here ...
http://www.rangefinderforum.com/photopost/showphoto.php?photo=43225&cat=500&ppuser=1182
... was lit from the front by incandescent (sodium? mixed?) street lights, and what shows through the window is fluorescent. You can tell the warmth of the front lighting, and the greenish tinge from the inside lights, but it's not unpleasant. This was done on fuji 800 with no tweaking of the color balance. This actually looks quite close to the scene as I remember it.
This next one ... I could never get right ...
http://www.rangefinderforum.com/photopost/showphoto.php?photo=26181&cat=500&ppuser=1182
This was taken at dusk with the Walgreens/Agfa 400 and when looking at the histograms, the blue is extremely weak. Too weak to be adjusted for a natural look. This next one is under similar circumstances, only a few blocks away but on a different evening, and was done on Fuji 800. No color correction.
http://www.rangefinderforum.com/photopost/showphoto.php?photo=30154&cat=500&ppuser=1182
This looks far more natural.
They tell me (the ubiquitous "they") that Fuji's "4th Color Layer" actually helps with this. I can believe it.
I also remember when I was very young and still had my Brownie Starflash, I bought (splurged, I did this rarely) a roll of Kodacolor and the guy at the drug store told me that with the new Kodacolor I should use CLEAR and not BLUE flash.
Later when I got my first real camera, I remember that for color print film (Kodacolor 2? Kodacolor X?) the indoor color rendition (at least when printed on the machines the mass produced places used) was quite acceptable, but for slides there was a pronounced orange cast.