Camera+, and Photogene2 to do some minimal creative editing. Once I have the edited version, I share using Path, Instagram, and Posterous. If I need a panoramic shot, I'll use Pano, and if I want to shoot an HDR, I'll use TrueHDR instead of the built-in HDR functionality of the iPhone camera app.
Lockergnome posted an article today featuring a video of Kris Krug about using your iPhone for photography. Hit that link for the full article, or watch the video below.