Only way I know to do this is to parent it to an empty atom. Put the empty where you want the pivot point to be, then parent the CUA to it. A similar problem exists in Daz. I couldn't tell you how many swords and knives I've seen that do not rotate about the handle, or the long axis.