As regards what stops I would assume most trains will with the possible exception of the non-stop London trains, but I could also see a need for an Ely to Cambridge South service for access to the hospital, so the Kings Lynn and Ely trains may stop too.
It's going to be a major traffic draw given the hospital and labs and the residential areas a short walk away. Indeed, taking pressure off Cambridge (not very Central) will also be a useful benefit of the new station.
My guess is that the following would stop:
Brighton to Cambridge (Central) (semi-fast) x2 per hour in each direction
London King’s Cross to Cambridge (Central) (slow) x 2 per hour in each direction
London Liverpool Street to Cambridge North x2 per hour (slow and semi-fast) in each direction
Stansted Airport to Norwich x1 per hour in each direction
With the following not stopping:
London King’s Cross to Ely x1 per hour (fast) in each direction
London King’s Cross to King’s Lynn x1 per hour (fast) in each direction
Stansted Airport to Birmingham New Street x1 per hour in each direction
However the above while potentially logical would leave some areas north of Cambridge North not that well connected with Ely only getting 1 train per hour and stations north of that on the Fen Line to King’s Lynn and Hereward Line to Peterborough requiring a change while Audley End, Whittlesford Parkway (3 per hour) and Royston, Baldock, Letchworth GC, Hitchin would get 4 per hour; stations east of Cambridge on the Newmarket line would require a change but there would be 7 trains an hour to Cambridge (Central).
As regards what stops I would assume most trains will with the possible exception of the non-stop London trains, but I could also see a need for an Ely to Cambridge South service for access to the hospital, so the Kings Lynn and Ely trains may stop too.
It's going to be a major traffic draw given the hospital and labs and the residential areas a short walk away. Indeed, taking pressure off Cambridge (not very Central) will also be a useful benefit of the new station.
Given the long distance cross country services between Stansted Airport and Birmingham New Street don’t stop at Cambridge North I would be surprised if they stop at Cambridge South.