The Tour takes pretty awesome pictures for a business phone (slide show). It lacks the accelerometer present in the Storm, so there is no auto-rotation, but it features a dedicated two-stage camera button, which is missing on most other devices with a similar form factor, like the Nokia E71.
I recently snapped matching shots with the Tour and the excellent Nokia N900. Although the N900 camera wins overall, the Tour camera holds its own – judge for yourself.
Video recording with the Tour is nothing to write home about, with a resolution of 480×352 pixel, and a frame rate of about 20 fps. Here is a sample video (download original):