I really love tilt shift photography and the look that it gives you. I could watch good TiltShift photography all day long. When I saw The Social network I thought the Henley Sequence was amazing. I understand using Tiltshift came out of necessity rather than a conscious decision but it really worked and it was pulled off.
Here is a nice video of a Day in Jackson Hole. There are some really cool shots in this video and looks like there was some sort of budget since it looks like there are some really nice helicopter shots in this video.
Here are some iPhone apps for faking Tiltshift. I've used Tiltshift Generator and it is worth every cent, its a great app.