Re: App Advice: Need Media Manager App for Remote Access via Airport Extreme
You might want to look at an App called "Pocket Space". I found it after searching the app store for an airport management app, and only this one and the official Apple airport manament tool appeared. I'm not sure if it's going to do exactly what you want, but that's all I could find that seems to come close to managing files through an AirPort Extreme or even FTP. I've never used it, and it's only .99 cents to buy, so please do some additional research if you don't want to part with a Dollar. I wasn't apple to find any additional reviews online or demos on YouTube either.
You also might want to take a look at "LogMeIn" too. This is a Remote Desktop app for the iPad and supposedly does allow you to directly sync photos to your Mac, just like you were plugged in to the USB port. I've never tried this one either, but I know people who use it and they love it. I think you can even access your Mac remotely through the AirPort Extreme too. There is also a pro LogMeIn app called Ignition that adds additional security for remote connections, but at $129.99 in the App Store, it might not be your cup of tea.
There are a bunch of photo management apps on the App Store, but I don't know of any that would do photos, videos and music all together. Have you called Apple and talked with one of their sales reps about the AirPort Extreme and what management options they might recommend? If you've got an Apple store nearby, you might want to stop in and find out who's the resident expert on the airports and see what they have to say and what they might recommend.
On a similar note, I feel your pain to some extent. I just wish Apple would completely do away with the whole "sync" concept, and allow us to move files back and forth from the camera roll at will, just like I've done for years under Windows Explorer. Apple products have a lot of Pro's, but file management isn't always one of them. I've always appreciated the file browsing concept that unfortunately we are unable to do due to the limitations of iOS. We're locked in the sandbox.
There are probably some jailbreak apps that allow these kinds of functions, but since I've not jail broken anything in years, I can't comment on that either.
I wish you the best of luck, and please post if you find something useful that works for you!