Picasa does this quite well. Under Tools -> Folder Manager, you can tell it where to look, and it's actually pretty good about picking up on new images within seconds of their being written. Picasa tries to pay attention to your load average, so it will (sometimes) delay scanning new pictures if your computer is busy doing something else.