Canon Lenses Types
Why is this type of lens (Canon TS-E tilt sliders)?

and what kind of results are used to r …

The slope and displacement of the lens is used primarily for control of perspective in architectural photography (ie, straightening tilted buildings). Here's an interesting Article on other uses: http://www.shutterbug.net/equipmentreviews/lenses/0801sb_tilt/