My Canon DSLR, for example, integrates well with the Eye-Fi cards. It keeps the camera powered on until the Wi-Fi media uploads are done, displays a Wi-Fi icon on the camera's touchscreen that shows the status of uploads, and allows enabling/disabling of the card from the camera's menu.
Setup of the Eye-Fi Mobi card for use with an iOS device is fast and easy. First, you install the free Eye-Fi app (universal, also available for Android and Kindle). The installation process requires that you enter the activation code that's on the back of the SD card case on the package; once that's done, the app installs a profile onto your iOS device. Next, the app asks for access to your Photo Library so that images sent from your DSLR can go right in without a need to be moved manually.
Your next step is to pop the card into your camera and enable it. Once that's done and you take a picture with the camera, the card sets up a secure Wi-Fi network that's tied to the app you activated. Select that network in the Settings app, and you're ready to roll.
Upon launching the app again, the photos are quickly uploaded to the iOS device. When I mean quickly, I mean that it takes only a few seconds for DSLR-quality images to be transferred at full resolution. I find this quite interesting, since the Eye-Fi to Mac connection on my home network is slower. In the future, I may use my iPhone as the intermediary for image transfers for reviews, since an Eye-Fi to iPhone to Mac (via Photo Stream sync) transfer is faster than what I've been seeing with a direct to Mac Wi-Fi connection.
One more great thing is that you can share the DSLR images while Eye-Fi transfers are taking place, since enabling the ad-hoc Wi-Fi network still keeps your cellular data connection up and running.
The Eye-Fi Mobi card comes in both 8 GB and 16 GB versions, and is available from many online retailers including Photojojo and Amazon as well as direct from Eye-Fi.