You should be looking for a program by BVRP Software called Mobile PhoneTools. Once you have that (my was just a simple mpt323.exe file), install it.
You then need to start the program, and tell it that you are using a USB cable. When it is waiting for the phone to be connected, plug it in and it *should* select the phone type, etc. automatically.
Once in the program (a picture of your cell phone will appear), the software will automatically enumerate with your cellphone. Click the picture of the bell with the music notes on the right.
When in the multimedia studio window, select mobile explorer, then from the lists available, copy over whichever photos you want/need.
Note that you can also use this software to make ringtones, transfer video, and synchronize as well.
I believe Motorolla is still selling the software on their website for ~$30 (US) still.