That Wikipedia article contains not all the window functions described in https://apps.dtic.mil/dtic/tr/fulltext/u2/a085032.pdf. I even found a windowing function that has -42dB/octave decay, what this means is the volume drops by a factor of 128 for each octave of frequency distance from the main frequency; for reference, Hanning has a -18dB/octave decay; this doesn’t necessarily mean it’s better to use this windowing function.

In theory, the sinc function window would produce no spectral leakage. However, the sinc function is of infinite length; it looks like instead of frequency spectral leakage, this theoretical window has temporal spectral leakage (spectral leakage in time).

Choosing the window function definitely involves various tradeoffs regarding the impulse response of both time and frequency.