Jean-Pierre Jeunet’s Alien: Resurrection, along with David Fincher’s Alien 3, are considered–and rightly so–to be the worse movies in the Alien franchise.
In reference to the the former, that’s probably true, but doesn’t tell the whole story. For instance, Joss Whedon (Serenity, The Avengers, Avengers: Age of Ultron) wrote the movie, and had a few things to say about the casting as well as how he final product veered from his screenplay.
Another point is that, despite the issues revolving around the casting or story–what’s the point of giving the Alien Queen the ability to reproduce like mammals do, anyway? Not only is it oftentimes painful (which may aid to bond the mother and her offspring), mammals typically produce much less offspring than insects, which the Aliens essentially are.
So when the entire premise of your movie is a wash, it’s typically a bad sign.
That being said, studioADI handled a lot of the practical special effects–Ripley models, the full-sized Alien Queen, etc–and their work is easily the best part of the movie.
And while it wasn’t not enough to save the movie, visually speaking, it came damn close.