Place it just before the visual payoff in a slapstick sequence, while the action is still building toward a break. Follow it with a fail sound if the object collapses, or leave the next beat for the character's reaction shot to carry the gag.
About this sound
This clip is a very brief stretchy creak that tightens then releases with a sharp pop, a classic cartoon sound effect with no voice. It feels tense and silly at once, like something is about to snap but in a playful slapstick way. It comes from the Donald Duck cartoon Donald's Gold Mine from 1942.