I was on the fence too because I didn’t want another thing to maintain. Ended up starting small with some solar path lights and a soft underwater LED, mostly for safety. The vibe change was immediate though. Once the sun went down, we actually started using the pool area more instead of heading inside. Late swims, people sitting around talking, whole space felt different.
What surprised me was how much the lights exposed the water. During the day everything looked fine, but at night you could see haze way easier. After a few evening hangouts with higher bather load, the water looked kinda tired under the lights even though chlorine was in range and pH was around 7.5. Filter pressure was creeping up too. I realized the lighting wasn’t the problem, it was just showing what was already there.
Now I plan around it. After busy nights I’ll use aquadoc flocculant, shut the pump off, and let everything settle. Next morning I vacuum the gunk, pressure drops a few psi, and the pool actually looks amazing under the lights again. So yeah, lighting is totally worth it, just be ready for it to call out your water balance if things aren’t dialed in. Once I got that sorted, nighttime became my favorite time out there.