Now, as said, this is only my own experiences, but I think that with all my time in WoW I would have seen this issue atleast once if it actually was one. A lot of people seem to share this opinion in this thread though, leading me to think that my experiences are not unique. The only people that seems to parade with the flag that being rotated makes people leave guilds, are the same people that always come with exaggerations, so forgive me if I take that with a grain of salt until some more reliable and neutral players come forth with the same opinion.
For all sense and purposes, the only scenarios that you have described with people getting mad because being rotated, has to me sound like guilds where the guild master has no business being guild master as he has (most likely) done quite a terrible job. The guilds you describe seem to have no set baseline or communication between members.