Hi,
My take on it is that Display Referred applications such as Adobe Photoshop should not be used anymore for texturing. I have pretty much never used it during the last decade, Mari, Nuke and more recently Substance Painter are the way to go. The only place where Photoshop has still a place is Digital Matte Painting but besides that, it is simply not equipped for modern productions.
I don’t really understand your last question 
The RRT is what maps the ACES values to an ideal reference display, producing OCES values, those values at then mapped to an effective target display using an ODT. The ODT is mostly responsible for fitting the OCES dynamic range into the smaller target display dynamic range.
While very elegant on the paper, the drawback of this approach is that it is extremely hard to control the look because the two separate functions, i.e. RRT and ODT are somehow antagonist, or at least do not play well together. If you modify the RRT, you need to change all the ODTs accordingly making it hard to define clear ownership of what function should do what. What has been done recently is combining them back together, via the so-called Single Stage Tone Scale (SSTS) transform, the resulting transformations are simply called Output Transforms: https://github.com/ampas/aces-dev/tree/master/transforms/ctl/outputTransforms
Cheers,
Thomas