You've posted this in the Logic sub-forum... I guess we don't have an iPad forum... but you can always use the "General forum" if you like in the future...
I do like my iPad a lot... granted I'm not a pro photographer... but it's very simple to transfer images from Camera, Flash card or Mac or iPhone 4 on to the iPad.
You need the separate accessory by Apple called the "Camera Connection kit".
As for apps... there are a few good ones around designed for photographers.... depends what you want to do with your Photos on the iPad exactly.
Currently, I use the built-in Photos app, which is a bit like iPhoto, but simpler. I imagine Apple will be adding more functionality to this in the future - but you can of course sync events, etc. between iPhoto and iPad if you want as well.
What kind of control/functionality are you looking for in an iPad app?