Want to do deep DOF Macro and from what I gather PC-E lenses can do this.
Sorry, it just isn’t true. For the same framing and aperture on the same sensor, the DoF will be the same; tilt-shift or regular lens.
You can tilt the lens and therefore change the plane of focus. This also changes the shape of the area in acceptable focus to a wedge shape, but the DoF is the same. All you can do is change where the focus lies.
If for instance if you where photographing something rather flat (like a lens filter), from an angle, then with a TS lens you could tilt the lens (or camera) so that the plane of focus was parallel with the surface of the filter.
May do architectural for fun but that's not the purpose right now. The 24mm would have the deepest DOF, but would require the closes lens-subject distance. 85mm just the opposite. Maybe the 45mm is the right one?
The focal length has very little impact on the DoF. 17 mm or 90 mm, the DoF will be almost the same for the same framing and relative aperture.
Brian A