I'd explore other options if your working with a standard house. It could be opening windows over night would do the job or shading out some patio area that heats the ground near the house. Find where the heat is coming from. If you have some white curtains to shut during the day it will reflect the light out. Dark curtains or any light coming in can heat a house a lot the moment it is warm enough outside for the glass to be ineffective at draining the heat. You could paint the roof white but that will make it colder in winter. Insulating the roof and possibly walls would probably be better year round. For cooling tubes maybe using water and connecting it to existing radiators would be better. You would just need a small pump or if there is some higher ground on the northside of the house you might not even need that. The problem is that the cool air sinks so it could just pull warm air down the chimney into the house and flow the wrong way. The solar chimney might be good enough to cool it down without any additional cooling tubes if the problem is just lack of suction. I am more experienced with the heating tubes where the condensation issue is perhaps less. However it can cause condensation inside if the walls are cold. It is effective tho and you can put it thru a solar panel after to push it into the house and increase ventilation. My idea is to have quite a big pipe so lots of preheated ventilation can be provided. This keeps the house pressurised and cold air won't leak in so much elsewhere. If you run a fire then instead of cold air coming in everywhere to feed it the big vent pipe can provide it and you get a better gain and hopefully keeps it dry. My concern with it is more plastic smell from the pipes. If there is enough ventilation then it should reduce condensation problem. If you wanted cooled air then probably best to look if there is a prevailing wind direction in these hot periods that could be used to push it in thru the pipe. Otherwise it might flow the wrong way and bring air down the chimney (which could already be happening and causing the issue).