I tried Batman: Arkham VR today. Wow.
It's not perfect (occasional calibration glitches) but it's the most immersive video game experience I've ever had. It's short, about an hour long, and I played through it in one sitting. A handful of scenes where you have to do detective work - no fighting or anything.
I also tried London Heist. Again, really immersive. It's really hard not to just start walking off in random directions - the sense of being there is that immersive. I picked up a cigar, lit it, smoked it. You can pick up objects and documents and rotate them in your hand naturally.
The main issue with these games is the whole walking around stuff. On the other hand, I found picking stuff up and pressing buttons and shooting all super intuitive. Reloading my gun in London Heist meant actually picking up a magazine in one hand, and physically putting it into the gun which was in the other hand. After the first time - which was more "huh? really? I just *do* it?" it's really natural.
This is all first gen stuff of course. Give it a year or two and it's going to be fantastic. The main issue, as I mentioned earlier, is the walking around. The Batman game solved that by having locations you can point to and just go to without actually walking there, which was fine for a slow paced detective game like that. Driving games where you stay seated will be a perfect fit.