The series never took itself totally seriously -- one of its virtues, in my opinion. Having said that, I rather like "The Changeling" (which features Teal'c as a firefighter).
Teal'c as a Firefighter was the first episode I ever watched, and it confused the hell out of me.
Much later, after seeing everything in context, that episode works pretty well in the grand scheme of things.
Yeah, the show always had a sense of humor about itself, but RDA really started phoning it in starting in season six.