Photoshop - replace multiple smart objects - find by name

You can give this a try, you need to amend theTifFolder, though, to the position on your D-Drive. 

In my test with this Folder-structure 

I get these updates:

// replace smart objects with tif with number plus one;
// 2023, use it at your own risk;
if (app.documents.length > 0) {
var myDocument = app.activeDocument;
// get renderings folder;
if (myDocument.name.indexOf(".") != -1) {var myDocName = myDocument.name.match(/(.*)\.[^\.]+$/)[1]}
else {var myDocName = myDocument.name};
try {var myPath = myDocument.path}
catch (e) {var myPath = "~/Desktop"};
var theTifFolder = Folder(Folder(myPath).parent+"/renderings");
// collect smart objects;
var theSmartObjects = collectSmartObjects2017();
var theRegExp = /_Cam\d{2}\.VRay/i;
// work through smart objects;
for (var m = 0; m < theSmartObjects.length; m++) {
    var theMatch = theSmartObjects[m][0].match(theRegExp);
    if (theMatch != null) {
        var theReplace = theSmartObjects[m][0].replace(theRegExp, "_Cam"+bufferNumberWithZeros(Number(String(theMatch).match(/\d{2}/))+1, 2)+".VRay");
        if (File(theTifFolder+"/"+theReplace+".tif").exists == true) {
// replace smart object it matching tif exists;
            replaceContents (File(theTifFolder+"/"+theReplace+".tif"), theSmartObjects[m][1]);
        };
    }
};
};
////////////////////////////////////
////// collect smart objects, probably based on code by paul, mike or x //////
function collectSmartObjects2017 () {
// get number of layers;
var ref = new ActionReference();
ref.putEnumerated( charIDToTypeID("Dcmn"), charIDToTypeID("Ordn"), charIDToTypeID("Trgt") ); 
var applicationDesc = executeActionGet(ref);
var theNumber = applicationDesc.getInteger(stringIDToTypeID("numberOfLayers"));
// process the layers;
var theLayers = new Array;
for (var m = 0; m <= theNumber; m++) {
try {
var ref = new ActionReference();
ref.putIndex( charIDToTypeID( "Lyr " ), m);
var layerDesc = executeActionGet(ref);
var layerSet = typeIDToStringID(layerDesc.getEnumerationValue(stringIDToTypeID("layerSection")));
var isBackground = layerDesc.getBoolean(stringIDToTypeID("background"));
// if not layer group collect values;
if (layerSet != "layerSectionEnd" && layerSet != "layerSectionStart" && isBackground != true) {
var theName = layerDesc.getString(stringIDToTypeID('name'));
var theID = layerDesc.getInteger(stringIDToTypeID('layerID'));
if(layerDesc.hasKey(stringIDToTypeID('smartObject'))) {theLayers.push([theName, theID])}
};
}
catch (e) {};
};
return theLayers
};
////// replace contents //////
function replaceContents (newFile, theSOId) {
selectLayerByID(theSOId, false);
// =======================================================
var idplacedLayerReplaceContents = stringIDToTypeID( "placedLayerReplaceContents" );
var desc3 = new ActionDescriptor();
var idnull = charIDToTypeID( "null" );
desc3.putPath( idnull, new File( newFile ) );
var idPgNm = charIDToTypeID( "PgNm" );
desc3.putInteger( idPgNm, 1 );
executeAction( idplacedLayerReplaceContents, desc3, DialogModes.NO );
return app.activeDocument.activeLayer
};
// based on code by mike hale, via paul riggott;
function selectLayerByID(id,add){ 
add = undefined ? add = false:add 
var ref = new ActionReference();
    ref.putIdentifier(charIDToTypeID("Lyr "), id);
    var desc = new ActionDescriptor();
    desc.putReference(charIDToTypeID("null"), ref );
       if(add) desc.putEnumerated( stringIDToTypeID( "selectionModifier" ), stringIDToTypeID( "selectionModifierType" ), stringIDToTypeID( "addToSelection" ) ); 
      desc.putBoolean( charIDToTypeID( "MkVs" ), false ); 
   try{
    executeAction(charIDToTypeID("slct"), desc, DialogModes.NO );
}catch(e){
alert(e.message); 
}
};
////// buffer number with zeros //////
function bufferNumberWithZeros (number, places) {
	var theNumberString = String(number);
	for (var o = 0; o < (places - String(number).length); o++) {
		theNumberString = String("0" + theNumberString)
		};
	return theNumberString
	};