From 2002 to 2007 I worked at the University and my wife and I sold up our family house and bought a flat in Cambridge with intention of settling there.
It quickly became apparent that Cambridge is a traffic nightmare and that the planners think you can build new houses and even new villages like Cambourne with only limited infrastructure investment, because all those new residents will go everywhere by public transport or bicycle.
Having ascertained that planners are nuts we eventually settled in Gloucestershire and I commuted by aeroplane between Kemble/Gloucester and Fowlmere/Cambridge as the weather dictated until I couldn't stand working at the University anymore.
Notwithstanding the issues around Bourn airfield, if it's built on, the surrounding area will be like living in Battersea, but with fewer facilities.