I have a fiberglass in ground pool. Because of the curve my installer installed a spa niche at the end of the 40 foot length. He said the normal size light is known for leaking on my model. I have had 2 different LED lights in the pool since it was built. Both had the long cord and the whole unit just slid into the niche. Both were 500 to 800$ and a major brand name. Both have failed after a couple years use. I have been seeing LED bulbs online now. They are like 100$ and look like they are meant to screw into a normal bulb socket. My niche is just like a round opening and has no place to screw a bulb into. Is there a way to convert my niche so I can use one of these bulbs?

Second question is a spa light does not do the best job lighting a 40 foot long pool. What's my best option to light this properly? Should I stay away from colors and go white? Is LED not good enough yet?

Ted