Building on the archives: Connecting the CN/CO intensity ratio with global galaxy properties in nearby U/LIRGs Preprints