Cambourne is like marmite indeed. The primary schools are big, but this year they were not all full in Reception for the first time - perhaps the birth-boom is tapering off. There are 3 proper Cambourne primaries (big though- 450 ish kids in each), plus the Blue School (Hardwick second campus) which has taken 34 children (in two classes) this year, and will be open for 5 years or so before a possible 4th permanent primary school is built on the new secondary school site.
Cambourne village college will open for age 11 in Sept 2013 as said above. It will be run by Comberton village college as a second campus. DKNYQueen is not right though - currently the vast majority of Cambourne secondary-age kids DO go to Comberton village college. Only those unlucky not to get in have to go further afield.
The infrastructure at Cambourne has improved markedly in the last couple of years, but I agree it is a big development. Good points are wide, safe, numerous footh/cycle paths (even little kids cycle to school safely away from the road), very easy to make friends (unlike the more established, older villages which can be cliquey), more house for your money, lakes and open green spaces to walk round (you won't see them from the roads), take-aways, Indian restaurant, pub (food only average), chemist, church (multi-faith), sports centre with good gym, classes, and activities for kids, plenty of playgrounds, supermarket etc. More shops are on the way for the high street, but planning rejected the original designs so they have to re-submit. The library is a great service. The doctors are nice but getting an appointment is a challenge. Comberton surgery was fabulous in comparison.
I've outed myself as a Cambourne resident here. PM me if you want any info, or a local to show you round on a speculative visit. My DH commutes by bike to work (not far from where your husband will be) in 30-50 mins (50 on the way home, tired and uphill). It's mostly off-road once you know the route.
There is plenty I don't like about it mind you! But that's the same everywhere.