We've seen no difference in the number of mosquitoes with a clear vs an amber
light. Other bugs like moths? Certainly a difference. At home we have seen a significant difference using our Mosquito Magnet
Propane system. The thing is though, it takes a few days running before the mosquitoes in your area have been trapped and killed off, plus it's a bit bulky, so it's impractical for camping. For camping, we prefer Ben's 100% DEET repellent. A few TINY spritzes will last you all day, and it doesn't have a strong odor like some other repellents - maybe because you don't use much.
This is coming from a long time tent camper - Ben's works.