Definitely. I'm about half way through 'Medal of Honor' on the Quest 2 and I've never really been in to war games (or movies) at all. But I've been having an absolutely great time doing the various missions - and training - where you get to mow down the nazis with a variety of weapons.
And naturally, different to a console game, I'm physically pointing the weapon (controller) at the (virtual) target. It's really more fun than it should be ;)
It feels like being a character in a (cheesy) WWII movie.
(Also, I don't think stabbing zombies in the head in 'Walking Dead :Saints and Sinners' will ever get old)