I've been an Aliens franchise fan for at least two decades now, and have played most of the games (certainly all the "major" releases). Aliens:CM is easily the worst entry into the franchise, made much more worse by the deception that preceded the release. AvP 2010 is ultimately a passable entry at best, but like Samus noted it was "underwhelming". Still, the game has its high points, the "club" scene early on in the game comes to mind.
Honestly the best game in the whole franchise likely remains that of the original AvP 2000 release. Randomized placement of enemies made every play through a bit different, and each of the three species really had strong campaigns of their own. Game is still creepy as hell to this day too.