Cambridge leads the field in producing Nobel science laureates, but many of the UK's best scientists have left to pursue work in the US. Matthew Reisz finds out from past winners what tempted them to go and why many feel the tide is turning in the UK's favour