I've used a 45mm TS-E for almost 10 years. If I was forced to choose & use only one lens, it'd be the 45. Unlike others here, I like its softness when shot wide open. I rarely go past f4 when using it.
Last year my first 45mm TS-E was stolen. I bought a new one, pulled it out of the box and tested it. Within 5 shutter clicks, the camera seized up and the LCD panel said "LENS MALFUNCTION. APERTURE FAILURE. ERR: XXX" (I forget the error number). I sent it back and got another one. While it worked, it's image quality wasn't as good as my original. It did not retain focus across the image plane when the movements were zeroed out. I used it for a few months and eventually sent it in to Canon Repair. Image quality is now what I expect. My lesson: Canon's lenses
do vary in quality.
When tilted to mid/extreme levels, you will see chromatic issues along lines of high contrast. These can be repaired with software, but it
is a drag to have to deal with it.
That said, I'm waiting for the revised version. I don't know if/when Canon will produce one, but given the success of the 17mm TS-E and 24mm TS-E II, I'm hoping for three new features: circular aperture blades, SWC lens coating, rotating collar for lens tilt. If/when Canon puts these features on their 45mm TS-E and 90mm TS-E, I'll be as happy as a pig in mud.