Can linear regression or any other models be used to judge if Y increases as X increases?
I don’t think linear model is a good idea for your problem, because it can capture only linear pattern. Furthermore, if I understand you correctly the results for different sites will not be comparable due to different scales/ slopes. 

Instead I suggest using the Spearman rank correlation coefficient.