As an avid, longstanding photographer, the whole issue of taking pics while on holiday is a vexing one. I always have a competition running in my head: one side is horrified at the thought of coming home with simple 'snaps' and so wants to take my 5kg of professional DSLR gear everywhere, while the other side wants to avoid turning the trip into a photoshoot, lugging all that expensive gear around and failing to see anything that wasn't in the viewfinder (also attracting thieves).
I have recently found a sort of accommodation for photogs like me (in other words, the Family Photographer PITA). The solution for me was to invest in a reasonably high-end 'compact' camera, in my case a Panasonic Lumix LX100. This amazing little camera, in terms of capability, sits somewhere between the ease of a point-and-shoot /smartphone, and a full-size DSLR. It satisfies my need for high image quality, having an extremely good lens (with plenty of wide angle - always useful on holiday) and a 'fast' aperture for lovely, shallow depth of field - great for isolating the subject from its background. Lots of auto settings mean it can be used by anybody, while its design and great little screen allows one-handed, discreet shooting that hopefully won't irritate your models (sorry, I mean family).
This isn't to say that I never miss the DSLR when on a trip, especially at night when a good DSLR will find light that a compact camera wouldn't know was there, but the advantages of light weight and unobtrusive packaging and operation, along with better than reasonable image quality, means I never miss the weight of the pro rig - and Mrs Wife doesn't have to wait around while I faff about trying to get the perfect shot with a DSLR and three lenses.
I have so far used the little Lumix on two big trips and I'm really happy with the result. An additional bonus is the ability to shoot frankly incredible video which, though not my thing, could be a real boon to folks who like to make holiday movies.
I'd be interested to hear how other photogs on this site deal with these issues and what solution or compromise they found (other than divorce).