We stopped taking our camera to the parks several trips ago and now just use our iPhone 4's. The picture quality has improved considerably (nowhere near DSLR quality, but perfectly acceptable for vacation photos and even blowing up to an 8x10). The nice thing is that I can easily have the best pictures online on Facebook the same day.
Here's one (shrunk down to 1/10th size for the forum) that was four separate iPhone pictures, stitched together into a panoramic with the Autostitch app:
Here's one (shrunk down to 640x480 for the forum) of my daughter in front of her favorite ride:
We always get the PhotoCD (usually through a photo share for about $25), and there are always good shots on that as well.
One big exception I'm going to make, though. On our next trip, we'll be staying at Animal Kingdom Villas in a Savannah View suite. I'll DEFINITELY be taking my camera for that.