I see myself using the iPad for this sort of quick-and-dirty post-shoot curation and showing off. Especially if I'm traveling and don't want to lug my full-on laptop with me.
I wonder if someone could come up with a Bluetooth or WiFi enabled mini-USB micro-dongle you could just leave plugged into the camera behind its media-port panel?
The Camera Connection Kit gives you two ways to import photos and videos from a digital camera. The Camera Connector lets you import your photos and videos to iPad using the camera’s USB cable. Or you can use the SD Card Reader to import photos and videos directly from the camera’s SD card.
Presumably these photos would get sync'd back up with your "real" iPhoto when you plug it in to iTunes.