Yeah, I've only heard of a couple of instances where a "cuke nuke" actually took place despite knowing multiple instances of cucumbers ejecting either a toxic fluid, their organs, or their cuvierian tubules, so it's definitely not a common event (at least not with sand sifting species). That said, keep in mind that the toxicity varies from one species to the next, and some species are more toxic in certain ways (some are more toxic when they expel toxins in some way, others contain more toxin in their body wall, etc.), and various circumstances (such as water volume, skimmers, running carbon or not, etc.) about the aquarium they're in can determine how much harm the toxin causes.
Personally, I'd say they generally seem pretty safe, but you need to be aware of the (relatively low) risk and have a plan in place to handle it if things go awry.
The cuke nukings:
Hi! Unfortunately, this morning I woke up to all my fish deceased, the sea cucumber and anemone also dead, with some gooey like slime stuck in my return pump. All of my crabs and snails are alive including my pom-pom, Anemone Crab and my Conchs, critters I thought to be extremely sensitive...
www.reef2reef.com
An instance of ejecting a fluid (nothing seemed to have been harmed in the tank, but this stuff is reportedly toxic):
Hey all, I recently got a black sea cucumber. I acclimated it with the drip method, and after a day it is now expelling this stuff. I've ready a lot about the toxicity, but I'm not sure if I should pull him now or not. All my SPS and fish seem to be fine.
www.reef2reef.com