I can't recall if this happens in any of the other series, but in Voyager I've noticed that lighting on the bridge (and, perhaps, other parts of the ship as well) dims whenever Red Alert is called. Why is this?
Common sense would dictate that low light conditions are a safety hazard as well as an eye strain. Sure, this may be somewhat acceptable when you want the ship to simulate a day/night cycle for the sake of crew comfort (as I can recall seeing once or twice in TNG). However, I do not think it would be sensible for this to be the chosen configuration during times when the crew needs to be functioning at peak efficiency.
If anything, I would expect that the ship's interior should be switched to maximum comfortable illumination levels during Red Alert - not minimal. I expect the out-of-universe explanation is that this is for dramatic effect, but is this otherwise justified or justifiable from an in-universe perspective?