Avoid the bigger towns if you can (St Ives, St Neots) and Huntingdon- on no account go anywhere near Oxmoor/ Sapley. Some of the Fenland towns (Ramsey, Chatteris) can be a bit 'strange'.
Lots of nice villages around though, especially to the West and South, ok around Cambridge too but more pricey.
Caution- Cambridgeshire is a very popular area for 'people who live in Caravans'. Check out around villages for sites. (Cottenham for instance).