While there are some insects which leave behind positive effects on your plants, aphids are unfortunately not one of them. Once they are done feeding they will destroy the plant and leave behind secretions which will cause either an invasion of ants or will grow fungus. Hence, there are no positive effects of cannabis aphids.