I put a bottle of slime in the Missus's mountain bike a couple of years ago. When I got the Aurora, I bought Marathon Plus Tours for it, and put the Auroras originals on her bike. It wasn't until I took off her old MB knobblies that I saw she'd had 2 punctures on the rear wheel. Both had sealed themselves before going flat. I think that if you get a puncture 1/2 way through a ride then it's got a good chance of re-sealing. However if you get one near the end of a ride, the tyre goes down before the slime can rotate enough times in the tube to create a seal, so it's a slime failure. I also experimented with a non-slime punctured tube by adding the slime, fitting to my MB, inflating/rotating and then riding on it......that was over a year ago and it's still o.k.
I suppose whether it works boils down to where in a ride you get a puncture, how big the hole is, whether the glass/thorn remains in the tyre, and a bit of luck. Like I say, it's worked for me in the past.
I have a proper slime tube on the rear of the Aurora. It doesn't add much weight, and if I'm unfortunate enough to actually get a puncture on a MP Tour, it can't hurt to have that little bit of extra protection can it?