The different methods you present are multiplications in the frequency domain and as such they are filters in time domain. The purpose of time-domain filters are to reduce the influence of off-band noise.
As I was myself interested in the differences and I'm working exactly on the same problem (multi-channel delay estimation) I applied the four methods and got the following picture

with exception of the plain CC all weighted methods are sharper with more or less similar noise levels.
The x-axis are samples and the data are from underwater recordings of a cetacean click recorded on two closely spaced hydrophones
Edit: The purpose of of methods (with exception of the CC method) is to pre-whiten the noise (flatten the spectrum), so one could conclude:
- CC: noise spectrum is already flat, no further action required
- Roth: both channels have same power spectra
- SCOT: both channels have different power spectra
- PHAT: effectively whitens the cross spectra (seems to be an ad-hoc method simplifying the Maximum Likelihood method).
Literature states that Roth and SCOT methods broaden the correlation peak, but this is very much likely a statement for (wide-sense-stationary) noise signals, as I cannot see this for the cetacean clicks shown in above picture.
Edit: while the peak in picture seems sharper for all but CC, the variability of the peak location is worse for all but CC. This means, that while peak is sharp, the location of the peak is uncertain, consistent with the widening aspect talked about in the literature.
Final selection will has to consider signal and background noise characteristics. Widely spaced sensors will have different background noise and uncorrelated signals, but closely spaced sensors will very likely only differ by time delay (phase shifts).
For my underwater click direction finding, the CC method (no spectral weighting) performs best. Worst is the Roth method, COTS and PHAT are slightly worse than CC as seen in following picture

In the top panel, which shows the azimuth the different methods are separated by 20 deg. for the elevation angle (bottom panel) the methods are separated by 10 deg. The x axis indicates seconds. The slow variations are due to sensor and animal movements.