How about just having Hazel copy the files from Photostream/iCloud/Dropbox to a named folder inside the folder Pictures?
True, you'd have to then tell LR to copy the files, but this would at least solve the awkward Copy to LR then delete from the phone which also deletes photos from Photostream.