In cop shows, how are women cops and detectives typically portrayed?

The question is about both positive and negative stereotypes and typical roles of male and female cops in the police drama and cop shows. I don't think it's unrealistic totally to portray a female cop who is very strong physically and mentally, is very athletic, a expert in martial arts and can beat most men in combat despite not having the bulkiness, or the same body mass of the males. The problem with this I hear is that when women are portrayed strong and courageous, they are bionic, 3rd degree black belts, or just sitcoms basically having mutant X-Men like powers. To me, Walker Texas Ranger's Sydney Cooke played by Nia Peeples and NCIS's Ziva David played by Cote de Pablo are examples of strong, fast, intelligent, and independent women played realistically, even when sometimes not totally realistic. The male cops abilities are rather exaggerated and unreal such as being able to beat up or kill much larger opponents with strength alone with no real fighting skills, and surviving gunshot wounds that would kill even the world's strongest man in real life.