I think he's in the Muppet Treasure movie, too.
I never liked the Rocky Horror Picture Show, I found it tasteless even as a teenager. But then I found Monty Python tasteless as well - at that age. But meanwhile I found myself liking most of Monty Python (my personal classic is "Confuse The Cat !"), no-one will make me watch the Rocky Horror Picture Show, as I still find it tasteless.
Some old habits never die.