wasn't even just an episode, it was an entire plotline.If I remember correctly the greatest threat humanity ever posed was that space corn that destroyed Cheyenne Mountain.
the more advanced races wanted nothing to do with humans until they saved the Asgard from the replicators and showed they could actually be a threat to the Goa'uld