LO and VLO depends on the frequency.
Something designed to be LO or VLO against X-band radars, like fighters, isn't going to be LO against longer wave radars, like S-band, L-band and metric wave. SPY-6 is an S-band radar. So is SPY-1D, Type 345X, SAMPSON, Top Plate and a whole bunch of others.
While longer wave radars can see and loosely track LO and VLO objects, in order to obtain missile quality high resolution tracking, you still need C-band, X-band and Ku-band (for gun quality tracking) radars. This is where the X-band VLO optimized design pays off. It ends up being able to see the target, but being unable to shoot it down. The result is that you merely end up seeing what is going to kill you.
Unfortunately, every mid to long ranged SAM missile in existence, relies on X-band radars. That means including every SM-2, SM-3, SM-6, every S-400, every S-300, Shtil, Buk, Aster, and so on. That includes AAMs too. It does not matter if its TVM, SARH or ARH is used for homing. Few missiles use C-band, namely Patriot and HQ-9, but sloped angles also affect the C-band too.
Using an X-band radar against a fighter will only trip the fighter's RWR. Missiles use CWI or Continuous Wave Illumination, which is a type of waveform different from Pulse radar, to home in on their targets, and RWRs can differentiate CWI from Pulse (Search) radar, and tell you that a missile is on its way for you, allowing you to take countermeasures.
Bombers, like flying wing designs such as B-2, are meant to be LO against longer frequency radars.