As far as specific brands names I like the Loc-Tite super glue gel. At HD or Lowe's. I like this particular brand cause it is so quick to thicken. You can put a blob on the rock rubble you're mounting to and stick the frag into the blob and it is immediately ready to replace back into the tank. Can't be any quicker.
DewMan the Mr. Sticky's works really well, or should I say it has worked really well for me. This hobby makes it so you can really tell people that it works awesome... Because sometimes it works for an individual and sometimes it doesn't.
This is an example of how I attach SPS. S. hytrix do not attach well, but will do so adequately. For Acropora and other SPS, they works perfectly with minimal rish of infection or loss of tissue. I use fishing line like this: