I believe e330 can do AutoFocus since the lenses have motor inside. Since there is no AF screw coupling on e330 (like D40). So e330 and D40 actually fall into the same category, no AF motor inside body. If you buy D40 and only buy AF-S lenses, you are doing the same like buying e330 and buy eSystem lenses.
I don't know how much e330 now, but D40 kit IIRC is below $1000.