Have you tried one of the newest generation headsets? Supposedly the higher frame rates counter motion sickness quite well. I haven't had anyone mention motion sickness when playing on my Valve Index (only when looking on a monitor how someone else plays, because the screen shakes so much then).
(The price of the Index definitely doesn't make it mainstream though. Just trying to get a sense of this issue)
Most people, even those prone to motion sickness, don't get sick in VR in current-gen hardware as long as it's a game where your view in the in-game world matches the view in the real world. This applies to many games. Beat Saber, PokerStars VR, and Zombie Training Simulator are examples of this.
On the other hand, any game where your movement in the game world doesn't match the real world is a quick path to sickness. Any racing or flying game makes me ill, and I've been playing VR for over 2 years.
On modern hardware, motion sickness is only really an issue in VR games which move your head around in-game in ways which don't match how you're moving in real life. Teleport and physical movement don't cause issues for most people.
The price and inherent limitations (such as motion sickness) of VR are going to ensure that it doesn't hit mainstream, at least for the time being