No redeeming features that in SG1 and spinoffs. I don't think the scriptwriters ever had the intention of enlightening us in any way. It was about a story to sell TV commercials. Seemed to have worked.
I have to admit that I liked SG1. It was fun to watch.