I have Velux sun tubes installed in my home, two 10 inch and one 21 inch. I am not endorsing the Velux products. At the time, they were the best choice for me and a I have been satisfied with their performance. The 21 inch has a 12 foot straight vertical run and is still very, very bright (I could have used a 17 or even a 14 inch). I had to cobble together parts from the residential and commercial kits to get what I wanted. The 10 inch have a 4 foot offset run. They light up a 40 ft hallway. I could have gotten by with one.
The diffuser technology has improved significantly (with integrated fluorescent or
LED) since I purchased mine. I may upgrade when I repaint next (will have to retire some light fixtures and will need to do some patching. Rigid tubing is preferable to flex tube, especially for long or offset runs.
I ran across the bottle skylight a few year ago. I like the addition of the LEDs. You will have to ad antifreeze in climates where it freezes. Rather than taping bottles together, try a tube. I do not know if the tube requires a reflective coating, if indeed the
water is the transfer medium. Shouldn't be expensive to find out, I suppose. Many years ago, a bomb
shelter company offered water-filled light tubes (20+ foot runs) to give natural light to their luxury bunkers in Southern Utah.