What is it with "queens" in SF ? Off to a rant :)
IMO, adding a queen to the Borg destroyed the Borg. I was really intrigued by the Borg as presented in their first appearance. If you remember, they had a nursery with Baby Borg and a collective conscience, no individuality. Then came the queen, the ruler of all with some people having a "higher rank". Totally made the Borg irrelevant to me.
There was a TV show about an invasion of Earth, it went along fine until the last season, a queen was added, I could tell it was rushed and doing that changed its direction.
Same can be said about Independence Day, even though I did not like the queen addition, it did not take away from the whole movie and in a way a "queen" in that context made a bit of sense. The only thing is, if the Queen was killed, wouldn't that end these Aliens ? To me, a queen should not leave the home planet.
Alien movies were too much for me, things popping out of someone's belly would be a "close my eyes" type scene. But I really liked Promentheus. I did not realize until much later that was a prequel to Alien :) And I still think it is a good movie.