I've got a Canon 7D DSLR and the iPad camera kit.
As far as storage goes, I'd rather just buy compact flash cards rather than put the camera photos on the iPad. The only advantage I see of being able to put photos on the iPad directly is to email them, or to show them to friends right away.
I do use the supplied photo album app to show off pictures. When I do this, I crop and downsize the images to 1024x768. This shrinks the average image size from 6 Megabytes to around 100 Kilobytes (The images look just as good when I do this and it saves many megabytes of storage). Then, I sync the processed images between my computer and the iPad using iTunes. This lets me group the images in folders...