Not having to be in one spot is pretty great, as is having wireless or a single cat5 instead of wiring a 100' plus snake to FOH. Digital also brings us total recall, scene navigation, highly customized matrix and "VCA" routing, multiple mixes, stage controllable monitors, built in recorder functionality... and that's off the top of my head. Reliability and redundancy are important considerations, as with any mission critical application, and you tend to get what you pay for in that respect, with the higher end digital consoles built to pass audio in the rare event of a crash. I would want a redundant control, no going with a single tablet alone. Having said that, a nice XL or Heritage is a thing of beauty.
I've worked on pretty much anything supplied. Occasionally things go south, lines, microphones, DI's, power mains, instruments, performers.. come to think of it I've seen all those things, but have yet to experience a digital console go down once. Maybe I'm just lucky.