VR porn is significantly better than flat video. It's like going from a five frame long 256x256 GIF on your cell phone to high res POV MP4 on a big screen TV. It's a big leap in experience. Whether it is 3D rendered stuff like this or stereoscopic recorded live performance (ex. wankzvr, etc).
You have to decide yourself it is worth the hardware cost. I would say probably not if you are strained financially.
Some older content did a bad job properly rendering videos, like screwing up the scale of the world so you feel like you are 2 feet tall or an ant. Or they jerk the camera around which causes motion sickness. Almost all content creators stopped doing this, again for renders live video recordings. Some very slow smooth camera movement can be good if used very carefully.
Anielszals actually does sort of "punch" or "knockback" the camera in some these videos, but its just small and quick enough to not cause motion sickness. I personally would still prefer it not be present, though.
Yes, video files need to be huge in filesize and resolution terms to not look blurry. You need a lot of disk space if you want to horde stuff. Content needs a lot of extra pixels, more than double because you not only have two eyes to feed but also a massive field of view. The video takes up your entire field of view with the goggles on, like putting your face inches away from large TV, so the blocky pixels of lower resolution stand out much more. 4k (3840x22160) is a good minimum but still won't look as clear as a 4K 2d picture. You also would need a newer headset like a Quest 2, Index, or Reverb G2 to make use of 5k+, as devices like the original Oculus not very high res for instance (like 1080x960 per eye?), but it still looks good and I'd say better than any 2D video because of the immersive experience of it. Maybe its bad if you have a fetish for skin blemishes or peach fuzz. Full 7k/8k with a newer headset looks amazing if you have all the right stuff. H.265 if your PC can decode it brings 7k/8k video file sizes down a lot without sacrificing quality, and most of the 7k/8k stuff now is h.265 and about the same size at 5k/6k h.264.
I think in general PC wise all you need is something like a 1660 or 1070 or so class card with 4GB+ of VRAM, maybe 6GB for high res stuff? It doesn't necessarily take a hyper-high power, you are just doing video decodes, not rendering polygons and such like you need for VAM. I don't know about Quest 2 streaming of PC videos, but there are options to do it over wifi if you have fast 5Ghz wifi. Air Link or Virtual Desktop, you'd have to look that up as I don't have a Quest 2.
VR porn game content is generally fairly lacking. VAM and Home Maid 3D are about it, and I don't generally care for anime. VAM has horrible, horrible performance even on an ultra high end PC. Everything else is dog shit. Just keep in mind if you invest the VR content world is much smaller than 2D. I.e. there are zero Ren'Py games for VR, and like 90% of the porn games on this site are ren'py games.
A lot of the rendered VR video "content" the short form loops are pretty boring just like all the 2D videos of the same sort of 3 second loops of shovelware IMO, but Anielszal's stuff is really next level. Like the Redmoa of VR. The detail and time put into facial animations and such is really good in VR. Even if its only ~20-30 seconds thats pretty good and far better than 2-3 second loops of garbage so many creators put out. I always think the longer form stuff is always better. Several minutes of actual animations, but only a tiny fraction of all content creators put that amount of effort in.