Nice find.
That camera is SMALL, at least width-wise. Moving the scene selector wheel to the right side (from the back) of the speedlight mount really lets them trim down the camera. Nice big screen, too. Looks like it retains enough features to be used by a point-and-shoot user wanting better low-light and a little more creative control.
No AF motor isn't a huge issue, as all the Nikon kit lenses are wannabe AF-S (integrated autofocus motor+gear, requires a physical switch to disengage for manual focus), and all the high-end ones are true AF-S (integrated autofocus motor around base of lens optics making an hourglass-shaped lens body, requires only a touch to the focus ring to switch to manual focus). The old lenses and the midrange ones (like 50mm primes and such) use the autofocus hookup in the camera.
Personally, I have a D50, and the D40 looks like a huge step down (I don't really care about multi-area autofocus, give me center area and I'm fine), but I really like having the information-dense top info panel. I still say that the D50 is the best bang-for-buck among DSLRs ($550 for body, $650 with 18-55mm, $850 with 18-55mm and 55-200mm). The only two features I'd like on my D50 would be an illuminated top panel and the ability to use the D50 as the master for an SB-800 remote speedlight group.