Yes. Solatube can bring in almost the equivalent of outside light. Its material on the inside of the tubing is almost 100% reflective, so whatever light is outside on the roof it can bring in to the home. Dont mistake some "copycat" brands with Solatube. You might have seen the cheapie Home Depot brand installed..not very good.
Of course on a cloudy rainy day, its not going to be bright but neither is it outside.
If you havent seen them installed, go visit one of their dealers that have them installed.