The are some marvelous lights on the market now. One is an LED strip that sticks on the underside of the arm of the sewing machine. This can be fabricated from parts at home improvement stores in the lighting department.
Another is a long light that reminds me of a flute; either floor or table mount.
Ott has some new LED lights.
Recently, I realized I get more meloncholy during winter. The solution has been a carpenters clamp on light attached to the curtain rod over my sewing maching with a plant-grow bulb.