the disintegration effect is even mocked in-world in a very meta way in later seasons.

Their meta mocking themselves is where I learned the phrase "hang a lantern on it" exactly because the writers "hung a lantern" on how silly the zat was.

Also several of the actors talk about how they're clearly penises. Like the first time they got their hand on one they went:

Also also, like 24 hours or so ago confirmed that new Stargate is being developed.