I've lived in Cambourne for 10 years on and off, with a couple of years in another nearby village. The amount of snobbery about the place in the surrounding area is incredible!
If you are looking for a community with lots of young families, plenty of community groups aimed at babies/toddlers/children and families, cycle lanes and pavements everywhere so you can walk everywhere with a buggy, and plenty of reasonably-priced property, I would visit the place before writing it off.
It has a Morrisons, a pharmacy, doctor, dentist, sports centre, library, and so on, so you can do lots of stuff without having to drive everywhere. Some of the other more picturesque (and pricy) villages have few or no facilities so you spend a fortune in petrol. It also has a regular bus service to Cambridge (several times hourly throughout the day), and you can cycle all the way on paths and cycle tracks. It is surrounded by a country park with miles of footpaths, several lakes, woodland and meadows, which is fantastic for cycling, running or simply going for a stroll.
It is currently in the catchment of Comberton Village College, and a new secondary school is being built in Cambourne itself which will be run by Comberton Village College. There are also 3 primary schools in Cambourne.
On the downside, it is a modern community (first houses completed in 1999) so there are no traditional buildings, the pub is pretty naff, and of course if you happen to reveal to parents from other villages or Cambridge itself that you are a Cambournite, they are react with amazement, as the local paper has persistently presented Cambourne as a rough place full of problem families... this is not the experience that me and most of my friends have had living here!