Half-life Alyx is pretty bad actually. Even I as a veteran get a tiny bit queasy with that occasionally - definitely wouldn't class it as one of my "safe" experiences. But even then "after a few hours" is pretty long really. Most people wouldn't stay in VR that long anyway.

Native Quest games are the best as they are entirely on-device with no latency anywhere.