I've bought a Vive when Half Life: Alyx came out and was completely blown away by the first impressions and immersions of that game.
Since then however and after the first "whoa!"-effects faded, every game was exactly what you've just described: Pure disappointment, and my body completely stressed out/sick after half an hour, at best. The only exception is beat-saber, which is a lot of fun for quite some time, but not the kind of game I'd want to play for hours on end.
So far, VR seems gimmicky, and quite frankly is way too much of a hassle to set up to enjoy it often (so many cables!, and I don't have the space for a permanent setup).