I have the 24L, 24-105, TS-E 24 II, TS-E 17. My TS-E 24 II is hands-down the sharpest of all my lenses, including the 70-200 f/2.8L II. It is super sharp without the tilt-shift, but is corner-to-corner sharp when the tilt is used properly, even at f/3.5. Although some use tables, LiveView is the easiest way to get that sharpness. My recommendation is to buy a clean used copy. They go for $1,750 USD or so.
how does the TSE-24II handle flare? I can point my 24LII at the sun and it almost completely kills any flare, in many cases it actually does kill it. For the creatives that like flare they will have a harder time getting that look if the 24LII is any indication of the future.
Um adding to the original post i decided to do what i should and investigate.http://www.the-digital-picture.com/Reviews/Canon-TS-E-24mm-f-3.5-L-II-Tilt-Shift-Lens-Review.aspx
"CA (Chromatic Aberration) is extremely well controlled - less CA than the EF 24 L II and much less than the original TS-E 24mm L. Utilizing SWC (Subwavelength Structure Coating), the TS-E 24 L II controls flare very well - performing much better than the EF 24 L II and better than the original TS-E 24mm L (review the comparison samples below). Distortion is negligible - slightly less than even the EF 24 L II and noticeably less than the original TS-E 24mm L. Contrast and colors are excellent. Bokeh (foreground and background blur quality) is good."
You just cant go below F3.5 which many who buy a 24 want. But as for landscapes it appears this Lens is the shizz.