Hi,
Concerning that question, keep in mind that the TSE offers a lot of shift, 12 mm and that is 1/3 - 1/2 of the frame. So 12 mm really correspond to 20 mm shift on 40 mm lens on full frame 645.
An interesting option is to use a Canon 11-24/4 zoom on a A7rII using either a T&S adapter or a Cambo Actus. The latter has a aperture selection with a special adapter plate.
The posters claiming that Rodenstock HR lenses on MFD outperform 24x36 mm are of course right. My sample of the 24/3.5 TSEII is the weakest of my 24 mm alternatives, Canon 16-35/4L, Sony 24-70/2.8 ZA and Canon 24/3.5TSE LII, but there are better samples than mine.
With shift you need to stop down the 24/3.5 TSE LII to f/11 - f/13. Shifted corners will not be sharp.
The advantage of the Sony A7rII route is that it can work with almost any lens, as the camera has a focal plane shutter and many lenses offer generous amount of shift. LCC and center filter are not needed and live view is very good for composition, magnified live view is great for accurate focus and peaking helps with finding optimal tilt.
Chris Barret switched from Phase One IQ260 to 24x36 mm, check this thread for some explanations:
...and I'm out.
The Canon 5DsR is of course great, but it doesn't offer the kind of flexibility the Sony has, because it has a mirror box.
All that said, a technical camera with great lenses and an MFD back will always outperform lesser systems in image quality, except in a few specific situation. But workflow is a bit more complicated, with some probability.
CMOS backs give good live view. Great for composition and magnified live view is probably best way to focus. LCC exposurs are needed with CMOS, too.
With CCD you need some decent way of focusing. Calibrated helicals like Alpa or Arca or a sliding back.
This may be a good intro:
Review: Linhof Techno
Samples:
Canon 24/3.5 TSE LII on Sony A7rII :
https://echophoto.smugmug.com/Technical/Canon-24-TSE-LII/
Canon 16-35/4L on HCam Master TS II/Sony A7rII, Canon 16-35/4 pre stopped down to f/11:
https://echophoto.smugmug.com/Technical/16-354l-and-Master-TS/
All images above are available in different sizes, up to full size. Some are stitched.
Best regards
Erik