So we just spent two weeks of spring break in Orlando, Florida, with six days at Disney. It was a great time. I never once considered taking my DSLR. But I did take my Sony RX100 as a proposed compact holiday/travel camera. I was with family, and the trip was all about family and fun.
In the end, I didn't take the RX100 out of its case, and exclusively used my iPhone 5 as my camera. I just didn't feel like it. As we walked around the resorts, I saw numerous people with slr's about their necks, and a handful of people with tripods and even a 70-200/2.8 behemoth. I thought to myself, "you're not here for the same reasons as me."
Most of the time, the iPhone was just right. It was always in my pocket, but never in the way. For outdoor shots, it was decent enough, though in particular the highlights were blown out of all recognition. Indoors, without the flashlight, it was very average and noisy. With the flashlight, the shots were disturbing and grey. For fireworks or nighttime lit subjects it was actually fairly effective. The most limiting thing was the autofocus. Very challenged in many situations, and I missed some good shots.
Doing it again, I would've attached the RX100 to my belt and used it. I would probably have an album of photos I'd want to look at. With the iPhone, I do have a sufficient record of the trip, and a few that can be printed. But it's not a very photo rich record of the trip. That said, I probably still have more photos to take home than I would have back in the film days.
Either way, I still would not have taken my dslr on this trip. Never missed it. It wasn't about scenery or portraits, and I was more interested in enjoying the next ride or attraction than trying to get some scenic shot of a resort that I can probably get somewhere online. I captured my family and some of the highlights in context. And not once did my wife complain about me stopping to take photos!