Samples of pictures taken with Canon's tilt-and-shift lens TS-E 24 L/3.5 lens on a 5D full frame camera. I have included some comments below most of the pictures (click on the pictures to read them). I believe this is a very good lens - and fun to use too. All pictures were shot handheld and with manual focus (this lens has no AF, but without tilt and shift the focus can be verified by the camera - half-press the shutter will give a green point in the viewfinder).

For further example, please visit my "Copenhagen architecure" gallery:
http://www.pbase.com/clandk/architecture

Some tilt-and-shift links:
http://www.cambridgeincolour.com/tutorials/tilt-shift-lenses2.htm (Tutorial)
http://www.pbase.com/dwerner/image/40583669 (Dave Werner TS-E 24 vs. 17-40)
http://www.pbase.com/djtowle/ts_pano (David Towle - pano example)
http://www.pbase.com/edhahn/work (Edward Hahn)
http://www.pbase.com/benjacobsen/canon_90mm_tse (Ben Jacobsen has a nice review of Canons TSE 90)
http://www.pbase.com/chrismuc/test_canon_24tse_vs_zeiss_21 (interesting Zeiss/Canon comparison)

http://users.gsinet.net/pjwhite/tilt-shift.htm (Great article about Scheimplug etc... )
http://www.fredmiranda.com/forum/topic/423046 (discussion at Fred Miranda)
http://www.photo.net/equipment/canon/tilt-shift (Frank Sheeran's article: "How Shift Lenses Change your Life"
http://hame.ca/tiltshift.htm (Major page with lots of links to tilt-and-shift web pages)
http://www.northlight-images.co.uk/article_pages/tilt_and_shift_ts-e.html
http://eosdoc.com/manuals/notes/tilt-shift_desc/
http://iso-100.com/canonwiki/index.php?title=Tilt_Shift_Lens_Techniques#Stitching_to_Increase_Image_Size
http://www.shiftlenses.com/ (Shop in Stockholm that has specilized in tilt-and-shift equipment)

http://www.mir.com.my/rb/photography/companies/canon/fdresources/fdlenses/35mmTS/35mmts.htm
has this advise for how to control the tilt such that foreground and background are in focus: "...First focus on the closest foreground object then tilt the lens until the background also comes into focus. You then make minor focus adjustments, close down the lens to the desired aperture and shoot...."