If you demand the ultimate in performance, the Pentax K10D should be on your shortlist. Featuring a 10.2-megapixel CCD, 2.5-inch LCD display, an SD/SDHC memory card slot, 11-point autofocus system, USB 2.0 connectivity, and a host of shooting modes. It goes on sale mid-October, priced at $799 (body only). Video overview after the jump.
The K10D has a few other things that put it ahead of the Canon [Digital Rebel XTi], though. Most notably, its image stabilization system that shifts the CCD in X, Y, and rotational directions, neutralizing your voyeuristic jitters, even without dedicated lenses