series is a useful point of reference not because it has a female lead, but because Fox kept pushing the producers to have a male lead instead. They felt that even the most successful films in the franchise could have done better at the box office with a male lead (the Alien Legacy box set has several interviews that indicate this, especially about Aliens
As for Catwoman
failing because they were bad movies, that may be so, but Hollywood has rarely tried to replicate quality, they've tried to replicate formula. Comic book movies with male leads have been successful, while ones with female leads have failed; thus, no more comic book movies with female leads (for as long as Hollywood, with its short memory, remembers those failures).