the 4' x 8' will give more light than a bunch of tubes any day.
A skylights performance is largely dependent on the lens material, tint, pattern, number, and shape of the lens. A blanket statement about the quality of the light and the quantity of PAR at the coral can vary greatly with those factors. Each needs to be measured.
Tube type skylights and traditional skylights have different applications based on the construction of the structure. For instance, how well does a skylight do for the ground floor of a two story building? Not well.
The best thing is to go large at top. Leave the framing in place
Light always obeys the inverse square law. A 30 degree slope, getting larger as it enters the room without interference creates the best situation for limiting the light loss. However, it is covering more area and less intense per square inch than originally.
line with reflective or paint white gloss. Go down to size needed at tank and use foam board with reflective side from home depot as your shaft. Bind this with reflective foil tape and your set. With this size, no need to buy the special coated material as needed in tube lighting.
I am sorry, but you are mistaken here. Tubular skylights try to "channel" the light into the room the same way fiber optic cable works. Signals within fiber optics are "bounced" through a property called "Total Internal Reflection". This is achieved through the densities of the material and creating a situation where it reflects without diffusion or refraction.
To achieve this in tubular skylights, aluminum sheet has a number of thin film layers applied to it. The differences in density of the materials creates this situation. Even so, this isn't perfect and any oil canning or irregularity due to seam, rivet, etc...compound the issue further.
When light interacts with a surface, some of it is absorbed by the surface, reflected in all directions and is diffused at the same time. The light "bounced" from white paint or foil would be useful in heat transfer, the quality and quantity of light from one bounce is worthless for reading, much less PAR for a coral. And I haven't even mentioned destructive interference of waves yet......
Also using prismatic reflectors at top in dome or set on your curb and another prismatic just above tank helps distribute light evenly and stop heat transfer.
Quality and Quantity of light is the issue, and if it is found in sufficient levels for corals to thrive. They evolved to use the energy direct, not diffused and shielded. No glazing is the best solution, a clear lens would be the second. Opaque prismatic lighting is great from human aesthetics and comfort....remember we are trying to supply up to 90% of the energy needs to sustain life, rather than conserve energy by not needing to turn on lights, which would be your traditional application of daylighting.