I think there are also Unintended Consequences to them, as there are with most things; I haven't thought about term limits enough to decide my opinion.

I would also say that whether or not one thinks something is Tyrannical has a lot to do with whether or not one agrees with it; one person's "Tyranny of the Majority" is another's "The Way Things Ought To Be."