All quite good examples but I would say that these are quite well known. It’s also missing that there are mitigation strategies for some - for e.g. in vibration analysis it’s typical to look at the Hann windowed data to remove the effect of partial cycles, and it’s common to overlap samples too. Similarly there are other tools like the Cepstrum which help you identify periodic peaks in the spectral data.

Fourier tutorials are a dime a dozen, so it would likely have been a better idea to link to his excellent wavelet tutorial at https://www.continuummechanics.org/wavelets.html . Good explanations of that concept are a lot harder to come by.