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.