It depends on the title. Most of them are just glorified tech demos or "experiences", and the most of the rest are garbage. Some of the best VR titles are just traditional games but with VR implementation - however, because VR is still so power hungry, it's mostly adaptations of older games which never had VR in mind. It's neat for homebrew cludge, but underwhelming for commercial products. Maybe this will get better over time as system power is able to reach much higher resolutions comfortably with no graphical or frame-rate compromises.
One of the biggest problems with VR right now is they're still not able to get over that "first impression" hump where genetically weak defects will get motion sick their first few times and will never use VR again. For hardware that's so expensive at the moment, that makes it very hard to produce the kind of mass market content which pays the bills. There's also only recently starting to form a sort of industry standard for VR hardware, so interfaces are starting to innovate less, and refine more. On the downside, this is going to kill creativity going forward. On the upswing, it's going to allow greater portability so that you can make a single large investment and just port it from system to system. Pretty sure Xbox has no plans for VR product lines exactly because they expect to just add compatibility for existing WMR headsets and a few of the more popular third party setups. Unless Sony conforms to the nascent industry standards, PSVR2 is going to flop even harder than PSVR. Nobody is going to want to put all the work into making a game PSVR2 compatible because Sony wants to pretend they're still the market leader in anything other than homo pride anymore.
VR isn't going anywhere, but it's a slow boil. Hopefully it does take off in popularity over the next generation - because for at least another decade or two, there's really no way to stream them and it will reinforce demand for local hardware and installation.