mixed
I´ve bought a PSVR on BF last year. the effect is neat at first but the more often you use it, the more accustomed you become to the experience till the point it loses much of the "wow!" feeling. it never amazed me in the way others reacted to the device though.
i can only speak for PSVR but i didn´t like the picture quality, very blurry(some games more than others). as someone wearing glasses i always had the feeling that this can´t be good for the eyes. you use a optical device to see better and look through a goggle which makes everything blurry again. felt wrong to me. (and regardless what anyone thinks about VR, this stuff can´t be good for the eyes, it is basically screens glued to your eyes at minimal distance.)
motion sickness was first no thing to me, played Wipeout for hours, Rez and other stuff and all was fine. one day i started R.I.G.S. and holy hell, that one got me real sick during the tutorial when you jump around. i´ve had hot flashes, was feeling dizzy and had to lay down for 2 hours. it felt awful.
many games where others say "real cool in VR" like Resident Evil 7 or Tetris Effect i found to be quite dull in VR. The picture quality ruins everything for me, too crumby, too blurry and somehow just bad. instead of immersing i found it more of a hindrance.
the best game was The Persistence, that felt really good to play. Polybius, Rez and Thumper were also cool. the rest was rather "meh". i also bought an Aim Controller and Firewall, Farpoint and a third game, can´t even remember what it was. super bad experience, lightguns back in the days were more fun.
sold the whole stuff around January because i wasn´t using the headset anymore. for me it was the modern equivalent of a Mega Cd back in the days: too little software that makes use of the hardware, many games with shoehorned VR modes or short "experiences" and in the end it isn´t worth it. also as someone without AC it isn´t really playable in the summer months so it is even more restricted when to use the thing.
without major advantages i don´t see myself going back to VR if i am honest. i think the tech still isn´t there yet. maybe in 5-10 years.