One useful feature for Photoshop workflows is the ability to export ICC Profiles and LUTs right from the plug-in. You can test out a color conversion directly on your pixels by running it normally. Then undo and export an ICC Profile that can be assigned to your document (make sure you save it in the proper directory). Or export a LUT to be assigned to a Color Lookup adjustment layer in Photoshop.
As usual, it's free and open source.
Enjoy!
Update: The October 2024 Photoshop update (26.0) added OCIO support natively. Use that instead!