I tried a wired Oculus (I think?) setup at a friend's house a few years ago for an evening, and it was fun but yes I could see the novelty wearing off quickly. Especially given the setup at the time would have been well over $1000 (once you consider upgrading to a powerful enough PC).

I considering getting a Quest 2 this year, as the price is a lot lower that what my friends setup would have cost, but after looking at a few "Top VR games" videos on YouTube I decided it wasn't for me. The videos were full of FPS and fighting games, which I can understand in VR would be a completely different experience and fun if you enjoy that, but that really isn't my thing. If more casual games come out then I could see it becoming more mainstream, but right now it does seem a bit of a fad.