Janusz Kaminski, frequent cinematographer for Steven Spielberg has utilized "Tilt shifters" in a few projects. Now Lens Baby has made a similar product available for the SLR market.

For still photography people utilize it to create "Fake miniature" photography. Meaning you take a photo of a real life setting and apply either a lens shift or some filters in Photoshop to create a "miniature" effect.