The Angular Momentum of the Circumgalactic Medium and its Connection to Galaxies in the Illustris and TNG Simulations