This was a confusing as heck when I started the hobby- so I understand your confusion.
lets see if this helps a bit more.... likely you are not using enough glue, gluing the frags too wet, or moving slightly them during the setting period
superglue will make a great bond, but will only glue dry to dry surfaces, and has little tolerance for being moved once it starts to set. I recommend starting to glue outside the tank till you get it figure out. set the SPS out for 15 minutes to dry (won't hurt it- as long as it isn't 50 degrees in the room

) take a piece of live rock rubble, and set it out too- after 15 or so, takes some paper towels and dab dry the areas you want to glue- the SPS will slime up a storm by this point in time. gluing over some flesh is ok- it will quickly grow back. Before you glue, "fit" the fra gto the rock, and get a plan- I usually like 3 good points of contact, or a hole to stick it into. Now, a good way to more quickly get a colony formed, than just keep a frag for a year- is to mount the frag sideways. this forces it to encrust faster, and "resets" the frag so it grows into your tank. put a descent glob of glue on the rock- dime sized or bigger, and press the frag into it, rotating it- then hold it in place once set for a few minutes- and then splash some water over the bond to make it set faster- keep it out of current for 20 minutes if possible
I have holes drilled all over my LR, and in LR rubble pieces so I can use rigid airline tubing as peg system- they arn't big or ugly, and make moving mounted corals an ease.
the epoxy way is an epoxy sandwich that is a plumbers epoxy ball in the center (great for filling big gaps, but not adhering to coral or rock) with a LOT (half a tube) of gel on each side. you jam the frag into the epoxy (grape sized or bigger) through a big blob of gel, so the super glue holds the frag to the epoxy, and then quickly push that to your liverock underwater.. the large blob of gel will form a bubble when you put in underwater, and your goal is to have enough that you puncture the gel bubble under water against the rock, exposing fresh superglue to the LR surface... then rotate back and forth a few times to work it in the crack, and hold in place for several minutes