Tube glue has it's purpose, which is to keep tubes from collapsing flat. I have a tube in my drawer for those odd occasions where it is easier to use the quick initial tack of a tube glue over any others.
CA stands for cyanoacrylate, a generic term for methyl 2-cyanoacrylate, AKA Superglue or Krazy Glue. Zap A Gap is just a brand name (owned by Superglue) targeted to hobbyists and is used to fill gaps in materials. Some CA glues are available in a thin, medium and thick formulation. If using to fill gaps, sand smooth shortly after the initial cure takes place (less than a minute usually), as CA glue that has fully cured (24 hours) is very hard to sand. I use it for gluing dissimilar materials, and use modeling putty for filling gaps.
CA has a strong "pull" strength, but a low "shear" strength. If you try to pull pieces glued with CA you'll likely fail. Give it a sideways tap and pieces can pop off easily. Especially if you put it in the freezer for a couple of hours.
CA polymerizes in the presence of water, and has an exothermic reaction, which can put out a surprising amount of heat, especially when combined with cotton. It needs to be stored in a tightly closed container in a dry place. Frost free freezers are a good place (the kind where you have to defrost is certain death). Many modelers have been chagrined to find their barely used bottle of CA hard as a rock after only a few months. Putting the container in a jar with a tight lid and a silica gel pack also works.
CA can be combined with an accelerator, usually a hydroxide ion base, for an instant cure. Sometime just breathing on it, like you would do when cleaning glasses, is all it takes. The water vapor in your breathe is more than sufficient for most applications. Try not to breathe in the fumes, as it fairly toxic and can trigger asthma. Even the vapors can adhere to the membranes in your mouth and nose which can be quite painful. CA can also irritate the skin through its exothermic behavior.
Like many products, CA was discovered 'by accident". It was developed by Kodak during experiments to create clearer lenses for bomb sights. They quickly realized it's potential for adhesion and developed it into the first "superglue". It was also used as an instant suture during the Vietnam War. 2-Octyl Cyanoacrylate was developed specifically for medical use, and has a much lower exothermic reaction, allowing it to be used as a surgical suture. It is now available for home use as LiquiBand or SurgiSeal.