Perhaps Sean Connery's most infamous (aka, worst) acting role has been the character Zed from the movie Zardoz.  It's a rather terrible old movie, but it's become a sort of cult classic (i would not recommend it though).  However, it did have some crazy imagery and ridiculous, hilarious costumes!