I put one in my last home. It's far less likely to leak over a conventional skylight since there is no straight edge to dam the water. It produced enough light that, if a full moon was above, I didn't have to turn on the light at night to walk to the toilet. During the day it produces plenty of light.
Mine was a
solatube brand.