Tenacious D in The Pick of Destiny
Some of the bits work; just as often, they don't. Black and Gass' appealing rapport masks those problems for a while, but eventually, they, too, wear out their welcome.