I hav a D40 and I love it. It is so easy to take photos with! I've taken about 2000 since I got mine Nov 2nd. I've charged the batteriy 3 times since then as well. One of those times was because I left the camera on overnight.
There is one lens that many people on scrapbook boards use, a 50mm that will not auto focus with it, you can still manually focus it though adn there is a version out that will autofocus with the D40, it costs more than the regular one. I didn't think of that as a deterent though, so I got the D40