Personally I’d not want to do it. I live North of Cambridge and really dislike days when I need to go into London.
I know a few people who have tried it for a while then bailed and either moved jobs, or moved closer to London.
As footflaps said, buying anywhere in travelling distance of the station is prime property, so depends how wealthy you are.
There is always the guided busway that heads into the station as well from as far out as St.Ives, but don’t move to any of the villages along that line as they are all terrible 😉 Heading south from the North side isn’t as bad as you’d expect (I regularly travel back to the Watford area and from Longstanton I’m on the A14 in minutes and it’s generally just over an hour to the M25 area.