Tube glue is simply liquid glue with familiar agents added to make it easier to apply and slower to set up so you can reposition parts. However, tube glue becomes stringy as it dries, and all the time that it's drying, it's eating away at your plastic, leaving familiar seems. On your first few kits, you may need more time to position pieces, so the longer setting time of tube glue may be desirable. Even better would be a slow-setting liquid cement, which combines the advantages of liquid cement with slower drying of tube glue to allow repositioning of parts. Cyanoacrylate adhesive, often called super glue adheres to plastic without melting it and cures chemically rather than drying through evaporation of solvents.
Many modellers think of super glue as the specialist.
It works on dissimilar materials and it's a must for gluing cast-resin kits and parts. Experienced builders also like super glue for fine styrene parts that might be marred of deformed by even a light application of liquid cement. But it takes careful handling, and yes, you can glue your fingers together with it.