This two-tone siren sound at the start of this video is the one that sends me chills.
I'd assume it's a recording of a British Carter siren, or some other similar 10/12 port one.
The tornado sirens I grew up with were pitched up from that at least a full octave but were extremely similar.