This is downright lame advice. The only reason the 24 is an L, is because it is a remarkable technical achievement. This holds for some other L lenses too, like the 28-300. It's hard to make an acceptable wideangle TS lens, I could explain this, but it would take quite some time - just trust me. Being L doesn't mean sh*t in this case. The other TS-E's are way better, but not wideangles.
The 45 and 90 have the same build quality, and their optical performance is much better than that of the 24 TS-E. The 24 is not bad, but clearly the worst of the lot. Of course, shifting makes most sense at this focal length, tilting the least compared to the others. Remember that ALL TS-E lenses are manual focus only. The E (electronic) means that they have an electronic diaphragm and they report to the camera to fill your EXIF data, help the flash, etc.
The tilt function means you can change the angle of your focal plane, the shift function allows perspective correction just like the lens distortion filter in PhotoShop, but then the hardware way.
The tilt function cannot be mimicked by software. With the tilt function you can, for example, photograph stuff on a table top from an angle with shallow DOF and align the focal plane with the table surface.
With the shift function you can photograph e.g. a building close-up without te typical wide-angle 'fall-over' look, but with 90 degree walls and constant width. These photo's still look weird though (= the effect can easily be overdone), because the upper part still looks like it's photographed from below, while the perspective doesn't match this.
These are truly specialty lenses. Don't buy any of these unless you're absolutely sure about what you want to do with it. They are all very different and dont share much purposes. I don't see any use for one of these (as some mentioned) for portrait photography. The poll between the three is like: what do you recommend? Trains, apples or girl's magazines?