There are several good female characters in the Stargate Universe. Obviously Sam Carter, but also e.g. Elisabeth Weir and Vala. A lot of strong female leaders among the various alien races as well. I really like Elisabeth Weir. She’s a diplomat and obviously out of her element working with the military, but she learns to adapt without losing what is important to her, which is being diplomatic and forging relationships as opposed to her military counterparts who’s sometimes rather shoot first and ask later. Both Stargate series show her being successful with that approach after getting used to the military.

I really like how Stargate has a pretty wide variety of female characters. From scientists to fighters to dipomates to evil powerhungry and cruel.