Molesworth became a ground-launched cruise missile base, with the runways and most of the WW2 infrastructure removed. The missiles and facilities were withdrawn in the 1990s, following the then latest Strategic Arms Limitations.
The site is currently the Joint Analysis Center (JAC) with the RAF and USAF, but in 2015 it was announced that the USAF would be withdrawing from both here, and Alconbury, and the facility is to be moved to a location in Northamptonshire.
I last passed the site in the early or mid 1990s, when some of the original accommodation buildings were being used, I think, to house refugees and other immigrants, but as far as I know, these buildings have since been demolished.