Don't know if I'd ever use it in a scene--it's just too good at sticking.
Creative use: My sister has smallish breasts and kept falling out of her strapless prom dress. My Dad came up with the idea of duct taping her into the top of the dress--it worked but she wasn't a happy camper when it came to taking it off (which might have also been his idea--lol).