Not your average run-of-the-mill lens, in fact I would only encourage it’s purchase after you have rented it at least 2 times and really know what you are getting into- it is expensive. Tilt shift lenses allow photographers to bend the DOF plan resulting in smaller strips if focus, while leaving the periphery in extreme bokeh and when used correctly, create a “miniature” type look, even with full size cityscapes.
Tilt shift lenses also allow for distorting architectural perspectives, and probably the most famous motion picture use of a tilt shift lens was in the movie “The Social Network” (rowing scene).
A handful of photographers are employing the 24mm TS as their signature portrait lens using only a strip of focus, or in creating very abstract type looks.
Fun to experiment with but definitely not a common lens that many photographers will have in their bags.