I do have to ask if you've tried modern VR at all because you really do have to try it.
Then you'll either 'get it' or you won't. The tastes within VR are pretty wide ranging, as are individual tolerances to simulation sickness.
I'm really fond of games where you get to hold a gun or weapon in your and and physically aim it at the targets, I also like the atmospheric benefits of 'being there'. I can't handle vehicular locomotion though, that sets off simulation sickness for me pretty badly but so did direct locomotion until I put some time into acclimatizing to it, I need to do the same with vehicles at some point.
What it actually does that standard games can't is absolutely unexplainable, it really has to be experienced. It has an impact on some games that would normally be boring where they suddenly become entertaining due to the admittedly gimmicky effect of it. Skyrim VR is a good example, it's a lot more entertaining than it should be, because of VR. Arizona Sunshine would be a boring as fuck linear zombie shooter on par with Land of the Dead: Road to Fiddlers Green, because of VR. Simple shooting galleries like Shooty Fruity or Ancient Amuletor, and wave shooters like Raw Data become a lot of fun where they'd normally be boring, because of VR. There's really nothing like the approaching enemy getting up close, you put the gun to their temple and pull the trigger.
VR games are visually boring to watch from the outside, I think because they have to be tooled to human reaction time and movement capabilities as opposed to just point and shoot with a cursor.
When you're actually inside of it though the pacing seems anything but slow.
A lot of the gimmicky/toy type games and experiences are a good chuckle often times too. Star Trek Bridge Crew looks like a boring piece of shit until you actually play it and then it's a hilarious blast.
I really think there's always going to be two kinds of people on the subject either way, those who 'get it' and those who don't.
That's not a dig at not getting it at all, just that it's like anything else with personal taste tied to it, you're going to see and be interested immediately or you're not, and that's probably going to be a solid indicator of what you're going to think of it long term.
You look at VR and don't see the appeal so it's very possible you still won't if you get into it.
VR right now is at the stage gaming was in the early to mid 80's, moving into late.
It's largely flat, one dimensional arcadey stuff that's very focused on a single objective/gameplay mechanic and those that do it well are a lot of fun and you can keep coming back to, those that don't are really, really shit.
Also, good VR porn is fucking phenomenal.
full disclosure: I got a VR unit totally for free so I don't have any sunk cost holding back my opinion of it