Don't know if I have any particularly decent "tilt" pictures (still trying to get a handle on how to use this to good effect). I mainly use the shift to keep perspective normal on buildings and get "more sky" in landscape photos. I'm not sure it will be very intersting, but I think I have a TSE photo from San Diego I could dig up (be patient with me, since this weekend will be pretty busy).
About a tripod, I know I've shot a few pictures without (just for kicks), but I think it's pretty hard to hold the camera, manipulate the tilt +/- shift, manual focus, set manual exposure, check the viewfinder, and (then, finally) think about composition. Plus, on a crop camera, I think it's hard to see most of the effects of the tilt/shift in the viewfinder. Honestly, I'm not sure how anyone could do it looking through a 1.6x Canon or 1.5x Nikon.