Diamond and Cubic Boron Nitride (CBN) super abrasive tips and bits for power-operated Chemical Mechanical Planarization (CMP) pad conditioning tools