I am almost exclusively a low power guy, generally using “traditional” materials.
My favorite water-based glues are Titebond II for most things, and Alleene’s Tacky Glue especially for motor mount installations (it is not as grabby), and especially when working on group builds. I use Alleene’s when joining tubes with couplers for the same reason (think Star Orbiter, for example).
For paper-to-plastic joints, there are water-based glues sold as “canopy glue” for the RC market which are good. And also @hcmbanjo’s favorite Beacon Fabri-tac and Foam-tac.
When epoxy is needed (motor retainers on PSII kits or when using the Estes screw-on retainers elsewhere, mostly) a 12-30 minute cure epoxy from Bob Smith is what I reAch for.
Thin CA gets used for hardening motor hook slots, the tops of body tubes where the nose cone/payload goes in (as a wear-mitigation strategy) and sometimes also the lower ends of motor mount tubes (same thing).
And seeing as it’s still Christmas morning where I am for a little less than an hour, Merry Christmas everyone.