There's no mistaking the Canon EOS 40D for one of the zillions of point-and-shoots or entry-level D-SLRs like the Nikon D40 or Canon Rebel XT. Check out our review for more!
If you want pure picture prowess, definitely consider the Sony alpha DSLR-A900. As we found out in our review, it's a great camera for the serious photographer.