Well I will admit that tv and movies are a LOT better than they used to be. But it still has a habit of shoving their female cast members into the background once the action starts.
What TV shows do this ? Most shows have women running in, beating up five guys twice their size and saving the day. Dollhouse is the new one, with Eliza Dushku knocking out huge hulking security guards with one punch and throwing hardened criminals up against lockers and holding them there.
The only show I can think of that actively kept its female lead out of action scenes was Stargate: Atlantis and there was a reason for that - they wanted Dr. Weir to be a specifically peaceful character to the point where she would never even be seen carrying a gun. They more than compensated for that with the invulnerable Super Ninja Teyla. I don't think that woman lost a fight in five years. She even beat up Ronon - the 6'4" guy who kills Wraith with his bare hands - in practice sessions.
I almost believe Enterprise should be praised for having T'Pol become, effectively, a drug addict. They didn't hide her away when the action started, though.
I suppose that's why I enjoy Battlestar Galactica so much. Every single important human character in that show, and some of the Cylons too, is a screw up in one way or another.
In more mainstream television, the almost inevitable path female characters follow is that they will get married, have a child and then become a single mother. They will juggle their career, motherhood and dating perfectly and succeed at all three.
I think people replying to this thread will really struggle to identify more than a few female lead characters on television who are
genuinely incompetent.