Photoshop opens TIFFs in Camera Raw Issue

It's not a bug, it's a user application setting preference.

A rendered file can't have raw camera file white balance.

You can't control how others have their settings – which means that your only other option is to remove the CRS metadata so that their software is forced to open a rendered file in Photoshop, not ACR by default.

Here is a script to remove CRS metadata from a single open file in Photoshop:

// Remove Camera Raw Settings CRS Metadata from Open Doc.jsx

#target photoshop

removeCRS();

function removeCRS() {
    if (!documents.length) return;
    if (ExternalObject.AdobeXMPScript == undefined) ExternalObject.AdobeXMPScript = new ExternalObject("lib:AdobeXMPScript");
    var xmp = new XMPMeta(activeDocument.xmpMetadata.rawData);
    XMPUtils.removeProperties(xmp,XMPConst.NS_CAMERA_RAW, "", XMPConst.REMOVE_ALL_PROPERTIES);
    app.activeDocument.xmpMetadata.rawData = xmp.serialize();
} 

While this Photoshop script will batch remove all CRS metadata from JPEG and TIFF and PSD files in a nominated folder:

// https://forums.adobe.com/thread/2584026

#target photoshop;    
  
var inputFolder= Folder.selectDialog ("Please select folder to process");    
  
if(inputFolder != null){    
  
var fileList  = inputFolder.getFiles(/\.(jpg|jpeg|tif|tiff|psd)$/i);    
  
for(var a in fileList){removeCRS(fileList[a]);}    
  
}    
  
function removeCRS(selectedFile) {       
   
  
if (ExternalObject.AdobeXMPScript == undefined) ExternalObject.AdobeXMPScript = new ExternalObject("lib:AdobeXMPScript");    
   
var xmpFile = new XMPFile( selectedFile.fsName, XMPConst.FILE_UNKNOWN, XMPConst.OPEN_FOR_UPDATE | XMPConst.OPEN_USE_SMART_HANDLER );     
  
var xmp = xmpFile.getXMP();    
  
XMPUtils.removeProperties(xmp,XMPConst.NS_CAMERA_RAW, "", XMPConst.REMOVE_ALL_PROPERTIES);  
  
if (xmpFile.canPutXMP(xmp)) {     
          
xmpFile.putXMP(xmp);    
           
xmpFile.closeFile(XMPConst.CLOSE_UPDATE_SAFELY);     
           
}             
   
  
};

The following script is for Adobe Bridge, not Photoshop:

// https://forums.adobe.com/message/9758205#9758205
#target bridge
if( BridgeTalk.appName == "bridge" ) {
remCRS = new MenuElement("command", "Remove Camera Raw Metadata",  "at the end of Tools");
}
remCRS.onSelect = function () {
if (ExternalObject.AdobeXMPScript == undefined) ExternalObject.AdobeXMPScript = new ExternalObject("lib:AdobeXMPScript");
var sels = app.document.selections;
for (var a in sels){
var thumb = new  Thumbnail(app.document.selections[a]);
var md = thumb.synchronousMetadata;
var xmp = new XMPMeta(md.serialize());
        if(thumb.hasMetadata){
         XMPUtils.removeProperties(xmp, XMPConst.NS_CAMERA_RAW, "", XMPConst.REMOVE_ALL_PROPERTIES);
        var updatedPacket = xmp.serialize(XMPConst.SERIALIZE_OMIT_PACKET_WRAPPER | XMPConst.SERIALIZE_USE_COMPACT_FORMAT);
        thumb.metadata = new Metadata(updatedPacket);
        }
    }
};

https://prepression.blogspot.com/2017/11/downloading-and-installing-adobe-scripts.html