One of the problems with using red light is that the roads don't show on the map (at least the ones in Canada).
And yes, roads are visible at night, courtesy of the traffic on them.
Conversely you can see the railroads on the map, but trains are fewer; so, are hard to spot on the ground at night.
Oh yes, three mile finals from 500' can get you more intimate with the trees than you might like. Night is a good time to fly a tight circuit.
If you can't see lights on the ground or stars, most likely you're inside a cloud