A reasonable workflow to copy Android photos to Photos

Here is how you can sync from Dropbox (or a directory of your choosing) into Photos, when new photos are added:

1. Open Automator, and create a "Folder Action"
2. On the top where it says "Folder Action receives files and folders added to" select "Choose folder", then "Other", and select your Dropbox folder (or whichever directory contains your photos)

3. Add a single Run AppleScript action with the following code:

   on run {input, parameters}
       set file_strings to {}
       repeat with current_file in input
           set file_as_string to (current_file as string)
           if words -2 through -1 of (do shell script "file --mime-type " & quoted form of (POSIX path of file file_as_string as string)) contains "image" then
               set file_strings to file_strings & {(file_as_string) as alias}
           end if
       end repeat
   
       tell application "Photos" to import file_strings
   end run
   

   Your Folder Action should look like this:

4. Now save it with a name of your choosing, and from now on, photos added to the folder you chose will be imported to Photos.

Let me know if anything goes wrong!

From Apple Support:

iPhoto automatically imports all photo stream photos into your library so you can keep them permanently (...)

Unless you disable "Automatic import" from the options, there is no need to manually copying them as they already are in your library.

Also, adding them to iPhoto albums does not make additional copies of the pictures, just lets you arrange links to the originals in any fashion you like. In fact if you remove a photo from an album:

The photos are removed only from this album, not from other albums or events in your photo library.

And neither from the library, for that matter.

This is because iPhoto albums work like labels, instead of being real folders (see an explanation here).

So to answer your question, enabling My Photo Stream on your iOS device and iPhoto, keeping auto import on, should suffice to have one copy of your pictures on your hard drive, given you regularly open iPhoto and have internet available for both (not necessarily concurrently ).

Note that videos are not uploaded via My Photo Stream, and that you may run into trouble if you take more than 1000 pictures or let more than 30 days go between each iPhoto session.

Check Apple's FAQ on the details of this limitations.

I would advise to implement some kind of backup anyway, as this scheme will at the most leave you with one —maybe two copies if you don't delete them from your iOS device. Time Machine is easy and free; for a dedicated picture/video solution check iCloud Photo Library (paid).

This information applies to the Photos app too at the moment of writing.