This lens is great for shooting product photography. I use it for food, shoes, bags, jewelry, and a lot of things. Sometimes, I add two macro rings and get fairly high magnification (like 1:1 or half life size) but the image quality is still very good, with almost zero chromatic aberration thanks to the true double Gauss design. However, when doing product photography, I want to have independent axes for tilt and shift. This lens ships with cross-axis configuration, which I changed to in-axis, which is a bit more useful, but frequently, I want 30 or 45-degree between those axes.
I also use it for corrective portraiture, when shooting headshots with people with round face, double chin, or some other difficult features. Since there is no autofocus, this is not the easiest thing to do, but people who are really conscious about their facial features will usually cooperate with me with this slow working lens, when I tell this is one of the best but unknown tricks anyone can use, combined with lighting technique, etc... If the model has no such issue, I prefer to shoot 85mm with AF.
I took one star away because I can't change the axes of tilt and shift independently.
Incidentally, TS-E 45mm is terrible at anything like half life size, and it gets a lot worse with tele converter. That lens is good for bigger objects.