We've got one in the kitchen of our Cabot Cove, installed by the previous/original owners. They had the opening take the place of one of the ceiling light fixtures and had a light add-on kit put into the tube. Thus it gives you what you want - daylight streaming into the kitchen via the solar tube - and also retains the use of the ceiling light. Plus it's one less thing on the ceiling of the kitchen!!
Bill