Well, I definitely notice the horrible mismatches in lighting styles. It really grates on me.
And although the average city dweller might not notice specifically that the lighting is mismatched, I am pretty certain they pick up the subliminal clue that mismatched design signals that this neighborhood doesn't matter. (i.e. the city doesn't care). Commonwealth Avenue in Back Bay -- all consistent lighting end to end. Chinatown, every lighting style the city has used in the past 100 years -- often 3-4 styles in the same block.
The city does tend to try to harmonize street lighting when they do a major street rebuild, like the Seaport Blvd. project, so there is hope they will clean up the hot design mess of lighting.