I laughed too when I told my friends (DVC members) about my experience at the rock n' roll rollarcoaster and I said "What are they conna go? Stop the coaster mid way?"
He said "Yes. He was actaully on one once where they stopped the ride to stop a person from videotapping."
So that's a story 1-friend removed.
The important thing is to follow the signs. They'll say "No video" or "No photography". Without the signs, don't worry about a thing. The can't "confiscate" a camera without warning. And even if they did, I'd bet the people get them back after the ride (I have yet to see a Disney "used" camera outlet on Ebay LOL).