I first remember hearing the effect in Roger's, I Want to Be Your Man...although not exactly like the Cher Effect, more like Bon Jovi's Living on a Prayer opening.
http://www.youtube.com/watch?v=6VEdPCvcOcc
They even made a HILARIOUS beer commercial using it.....

But in music i think it is a cheesy, cornball effect.....its like if every group decided to write a song using the kazoo...


What do you think?