So apparently, we've been thinking about this phenomenon all wrong. Moths & bugs etc... aren't actually being attracted to light. Most flying insects are instinctually driven to orient themselves with their backs to the sun or moon, as a means to properly direct their flight. Artificial light sources disrupt that instinct, causing them to reorient themselves in such a way as to unintentionally force them to orbit it, as if it were the proper orientation that would emanate from natural light. Basically, they can't help but angle their dorsal sides toward it.
As such, the worst types of artificial light for them are ones that are oppositely oriented, emanating from the ground up, because it completely reverses their normal orientation. We are essentially confusing their instinct to use natural light to navigate, and trapping them in an uncontrollable & inescapable torment.
I'd even be concerned that this could, in itself, have negative effects on pollinators, which we do a lot to interfere with.
As such, the worst types of artificial light for them are ones that are oppositely oriented, emanating from the ground up, because it completely reverses their normal orientation. We are essentially confusing their instinct to use natural light to navigate, and trapping them in an uncontrollable & inescapable torment.

I'd even be concerned that this could, in itself, have negative effects on pollinators, which we do a lot to interfere with.
