You can manually exposure bracket with a D40, and most other cameras
Discussion Forums @ Nikonians - D40
As to lenses with focus motors, the speed up focus on all bodies and are a godsend. The benefits far outway the small additional cost, and a 55-200 VR AF-S is down to £120.