I am absoutely in favor of term limits for all branches of the government.
Relying on the voters to overcome their own inertia to remove poorly performing incumbents has not been effective in limiting Congress. I think the Congressional limit should be 4 terms for Senators, and 12 terms for Representatives, resulting in no member of Congress serving more than 24 years (6 presidential terms). Obviously, voters can make a change at any time.
For the Supreme Court, I think a limit of 30 years is appropriate. That's equivalent to 5 Senatorial terms, 15 Representative terms, and 7.5 Presidential terms.
I am not in favor of 1-2 term limits for Congress, because I think it is important to not rob the legislative of experience.