CA is too brittle for a glue joint you want to last. It does not have much shear strength and you can easily break the joint with simply shear pressure. I only use CA on wood when regular wood glue will not work well or I cannot clamp something small in place. My most common use is to fix something small that broke off, especially when it is difficult to clamp in place without it moving around and when I do not have to worry about shear force breaking it off againg. Even then, I will use hide glue if I can because it works well with rub joints.
My most common use of CA as an adhesive is for something like a turquoise inlay. I fill pockets, cracks and knots with ground turquoise (basically sand consistency) and dribble CA over it in layers until all the space around the sand if filled. Much neater than using epoxy, though staining around the area can cause issues.
--Nathan, TX. Hire the lazy man. He may not do as much work but that's because he will find a better way.