I have put thousands of miles on tires mounted with tufo tape and had no problems with the tires wanting to come off. I've used it for racing tight criteriums and downhills of 50 mph. In fact it takes almost too much force to get a tire off the rim (kills my thumbs). After removing a tire, the tape stays on the tire, leaving the rim almost totally clean.
The positive of using the tape is that you can immediately ride the tire. Make sure the rim is clean (furniture paint stripper can remove old rim cement). Also, be careful to place the tire squarely on the rim the first time as you can't easily slide the tire around a bit like you might with a liquid cement.
The negatives: if you get a flat away from home (if you're not using them for just racing), you have to carry tape as well as a tire (and it's difficult to carry the tape without mashing it which then makes it very difficult to unfold); also carry a small knife or scissors to trim the excess length off. Also, the tape tends to be just a bit wider than my rims, so there's usually a bit that is exposed along the edge which can look tacky and sometimes peel off in little strips.
