Yeah the pivot it's going to be always in the middle of the attachment.
If you want to move things easily around create a bone, make the attachment child of it, then use the bone to rotate the attachment as you wish before reparenting it to the correct place and delete the bone.