I want something that can manage my iPhone photo collection as well as sync them back to my PC for back up.
You can use Syncios -
You can find some recommendations in the following thread
"What is the best photo management app for iOS?"
Usually you are better off using the default "Photos" app on iOS, syncing photos via iTunes and doing most of your managing on the computer with your preferred software e.g. Picasa