I agree with the comments, it is a superb lens in every aspect. I own one since almost 2 years now as well as a 90mm TS-E. I bought it mainly for architecture work, but in the end more than 50% of my work is done with it (mainly indoors architecture, landscape and gardens). I am a big fan of wide angles and the 24mm is so to say my standard lens. It's almost like having the possibilities of a view camera, but much easier to use thanks to the live view.
I can confirm the the model 2 is a huge improvement over the version 1, that was a very average lens. It's much better optically (almost no CA, extremely low barrel distortion excellent sharpness) and the new mechanical system really adds to its versatility.
Coming from the 4x5 world, I was always extremely frustrated by the fixed direction of the shift related to the tilt on every other TS / PC lens. This 24mm TS/E itself is the very item that prevents me to buy a D800.
My 2 cents about the cons though : the locking screws for the movements are really a pain in the ass. they barely tighten the lens enough, but get stuck very easily.
About the sharpness, it is very sharp all over the field, but under some circumstances it may appear less sharp as other lenses. In my case, I use DxO as a RAW converter, that applies by default some sharpening (much better than a simple sharpen filter in PS) on the lenses that have a correction module for it. As there is no correction module available for the TS-E lenses due to the changing nature of the image circle, it may appear softer than my 24-105L (for example), if no sharpening is added. To me distortion is never a problem but I need a little extra sharpening compared to the lenses that have a module in DxO, as the software always gives extra sharp images by default for the corrected lenses.
Aside from that it is a very big and heavy lens (I was shocked when I opened the box), with a large 82mm filter thread (seems to become the new pro lenses standard).
The focus ring is a pleasure on itself, smooth and greasy like a Leica lens.
In one word if I had to keep one lens in my collection, the 24 TS-E would be the one.
One word as well about the 90mm TS-E; although it lacks the same independent tilt / shift feature of the 17mm and 24mm II, this is simply the sharpest tele lens I ever had, period. that stuff is simply amazing, sharper than the 100mm macro, but with much more possibilities due to the tilt function. It focuses very close and in combination with the EF macro tubes, it has replaced without regrets my 100mm macro. I just wish it would have the improved mechanics of the 24mm, but the optics are so sharp, I can live with it.
Thought I would have great use for it, I did not buy the 45mm since here a version 2 would be a must; the separate tilt / shift is really missing on such a versatile lens, and optically it is very, very average, not worth the money IMO. Please Canon push a bit of the version 2 of the 45mm, it needs urgent replacement.
Now I am thinking about the 17mm TS-E, I am just a bit scared about the protruding lens with no hood for protection.
One thing I forgot, the 24mm TS-E is compatible with the extender 1.4 (though I can only speak for version 2), that gives a very decent 34mm TS-E.