Girton and Barton are much better bets than Dry Drayton and Harlton in terms of facilities. There's no shop or school in Harlton (but there is a brilliant wood!). There's a school and a pub but no shop in Dry Drayton, and it gets an awful lot of through traffic as it's the only way to get from the villages south of the A428 to Bar Hill Tesco. There has been talk of closing the junction from Dry Drayton onto the A14, which would stop the through traffic but would also mean that people living in Dry Drayton couldn't easily access the A14.
In terms of getting to Bedford, you'd be going against the traffic, so that would be good. Barton has got a good village shop and a nice community feel. However, the school is very small. That might not put you off, but my dc started off in a village school with 2 year groups per class and one of them really struggled with that. Comberton and Bourn both have one year group per class. Bourn is an exceptionally good school ime (my dc ended up there).
Comberton, Bourn and Hardwick all have a lot of facilities. Hardwick has great sports ground, skate park etc, nice pub and good village shop. Comberton has a good shop, dentist, GP surgery, butchers and of course Comberton Village College although your dd is a long way off that age. Bourn has a good village shop, nice (but pricy!) pub, good nursery school, lovely primary, GP surgery, dentist, tea shop and butchers.
The best thing to do is go and visit. Also, I know you say Cambourne isn't your thing, but people who live there love it and there are loads of activities going on there for children - sports, arts, drama, music etc. It's worth being within cycling distance of Cambourne to access those opportunities.