It happened to me a few times in good old CivI. My empire was so glorious two, I think Zulu cities, defected to me within a few turns. I really enjoyed that.
However, once I actually lost a city this way to the Germans. It was a real blow to my empire at that point.
I've never seen this in CivII till now though.
Well, then I have something new to try out...