Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.
This should already happen if you sync your photos. Try going into iPhoto and checking the option for what happens when you connect a camera. Make sure it says to open iPhoto.
 
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.