If you are just wanting something to manage content that you can insert photos into, then PowerCMS is great.
If you want a full blown dynamic photo gallery where a user can create albums and then add photos to albums and give them names you will the big dogs like DataAssist, Digital File Pro, etc.
You can combine both to do great things. My site has PowerCMS combined with all the other tools.
If you can clarify with a few more specifics, some members here can probably offer even more specific/appropriate advice.
Cheers,
Brian