you typically hear it layered over kicks in old school hip-hop, electro (old school electro, not electro house), breaks, freestyle, etc.
it's probably most recognizable from Planet Rock, you can hear it starting at 0:16
in this Flying Steps track, you hear it at 0:28. then it sounds like it goes up +1 octave at 1:39
Jazze Pha also used it in Ciara's "1, 2 Step" at 0:26
Looney4Clooney
fair light orch hit.
probably ripped form trevor horn somewhere. Ask Rann . GOogle fair light orchestra hit. And you will get it.
the other examples i have no idea what you are referring to. But that first example on top of the kick is the fair light . The other one sound like sine sweeps of some sort. I don't see any similarity . You sure those times are right.