There are many games worth playing so your one major point is simply false (other than potentially handwaving it all as crap without ever trying it or being one of those people who only ever praise AAA Uncharted-likes, similar to what fanboys/haters do for platforms like Switch, Wii or even PC). Your gifs of people being stupid and your complete misrepresentation of what the tech involves is silly, just as people wouldn't handwave flat gaming as all crap by showing random youtube videos of raging idiots falling off their gamer chairs or smashing their PC setup or whatever.
Here is a preliminary PC VR focused (plenty are on other platforms too) list of VR games I can recommend
, obviously always depending on one's preferences (even excluding obvious must have shit like Beat Saber and Half-Life: Alyx). I go back to it once in a while to add new games and even trim others that are still worthwhile just to keep it relatively short, it's only to get people started really. Oh, and this is all perfectly playable on my original Rift CV1 ~5 years from its launch, you don't need to upgrade often just as you don't buy new keyboards, mice or monitors all the time.
The Walking Dead: Saints & Sinners is an immersive sim-lite full of tense action alongside some scavenging and crafting.
Cosmodread is an expertly crafted roguelite adventure like a mix between System Shock 2 and Dreadhalls.
Vengeful Rites is an RPG with reactive melee, gesture based spell casting, exploration, puzzles & bosses galore.
Eye of the Temple is an inventive adventure that will bring out your inner Indiana Jones with its clever room scale shenanigans.
VTOL VR is a really cool light simulator of combat aircraft with amazing interactive cockpits perfectly suited for VR.
Song in the Smoke is a made for VR survival action adventure with a clear narrative attempting to immerse and amaze.
Budget Cuts is a stealth puzzle adventure series with well integrated teleportation mechanics & humour.
RC Rush is a polished racing game injecting VR zaniness to otherwise realistic remote controlled car races.
Squingle is a unique puzzle game with abstract visuals & design that's hard to describe and hard to put down.
Apex Construct is a sci fi action adventure game with archery and exploration in its post apocalyptic core.
Myst is the legendary adventure once again reimagined with all that made it special making a great transition to VR.
Vermillion is an incredibly realistic oil painting application that will bring out your inner Bob Ross.
Cubism is a wonderful puzzle game that's sure to entertain your neglected grey matter.
I Expect you to Die and its sequel will make you think and laugh with their secret agent themed escapades.
Airborn and SwarmVR are arcade shooters turning you into a flying & grapple hook swinging gun wielding hero respectively.
Eternal Starlight is a smart, intuitive, comprehensive space based Real-Time Strategy game a la Homeworld.
Battlegroup VR is another RTS where you direct your space fleet in first person from the bridge of your flagship.
Grapple Tournament is a next gen PVP arena FPS like UT/Quake with all the classic genre trappings redefined for VR.
Stormland is an open world shooter, more limited than its scope hints at first but still fun as hell.
Forewarned is a 1-4 player co-op horror game with inventive challenges set within procedurally generated Egyptian ruins.
MaskMaker is an adventure that will have you crafting and using magical masks as portals to other worlds.
The Room VR is a wonderful continuation of the famous puzzle adventure series, perfectly adapted to VR.
A Rogue Escape is another puzzle adventure with very unique themes and mechanics to check out.
VR Skater wants to make a Tony Hawk out of you, except you'll be using your hands instead of feet to perform tricks.
HoVRboard and Jet Island tried this concept first with sci fi trappings & the latter as part of an action game.
The Thrill of the Fight is a tried & true exhausting boxing simulator, if less fancy than the more gamey Creed.
Journey of the Gods is a Zelda-lite linear action adventure that's simple but polished and works really well.
Stones of Harlath is an indie RPG with many things going for it, from its retro looks to the satisfying combat.
Vertigo Remastered is a robust Half-Lifesque immersing and bizarre adventure with a spectacular sequel on the way.
Pistol Whip is a violently cool rhythm shooter, I love it like it’s a funky, musical Virtua Cop-like.
Everslaught is a fast action roguelite with melee and ranged combat, cool skills, perks and tools like a grappling hook.
Drop Dead is a fun riff on The House of the Dead, not nearly as tight as Sega's but maybe the best for VR.
Racket: Nx is a unique blend of skill, puzzle and high score fueled addictiveness that's worth checking out.
SUPERHOT VR is a puzzle action shooter with cool slow motion mechanics. Be like Neo.
Compound is a modern take on the boomer shooter genre with procedurally generated elements.
DeMagnete VR is a Portal style adventure that will challenge your brain with its magnetic force based puzzles.
Gorilla Tag is exactly what it says. It's free so you have nothing to lose, except your sense of time.
Synth Riders and OhShape are two popular rhythm games to move your hips and dance to like there's no tomorrow.
Eleven: Table Tennis is a table tennis game (duh) said to be the most sureally realistic yet, with a focus on PVP.
Moss is a third person action adventure where you lead a sword wielding mouse as if in a diorama of a fairy tale.
Lucky's Tale and Ven Adventure are, similarly to Moss, traditional third person platform action games with a VR twist.
Down the Rabbit Hole is another classic fairy tale adapted to VR, with its own twists, turns and style.
Asgard's Wrath is a lengthy made-for-VR action RPG with a Viking theme that many gamers vouch for.
Unplugged, BoomBox and Ragnarock are the new kids on the rhythm game block that everyone seems to love.
Ultrawings is a flight game, not quite a sim, maybe a bit like pilot wings in ways, with a sequel on the way.
Windlands 2 is an action adventure with grapple-hook-swinging and archery at its core, it’s also co-op capable.
Vox Machinae is a PVP focused giant mech combat game with awesome interactive cockpits.
Stride brings the premise of Mirror's Edge's parkour in VR with inventive controls and game modes.
Dash Dash World is a cartoony kart racer with no shortage of tracks and modes for solo or online play.
Demeo is a recent and already popular tabletop/pen & paper/Dungeons & Dragons type game you can play with your friends.
Ancient Dungeon is already the best VR dungeon crawler even though it's atm a free alpha, coming to proper early access soon.
Onward*, Contractors, Pavlov and other popular VR FPS games put their own twist to the military theme and style of play.
Population: One is atm the most popular VR Battle Royale FPS, it's arcadey with crosshair, simplified reloading, etc.
Waltz of the Wizard was initially a cool magical toybox but just received a huge free expansion with combat and other scenarios.
Blade & Sorcery has the best physics based melee combat but doesn’t yet have a campaign, though the recent Dungeons update helps.
Alternative takes on fantasy slashing are offered by Gorn, Swordsman, Until You Fall, Swords of Gargantua and Hellsplit: Arena.
Hard Bullet meanwhile takes the arena combat concept to modern weaponry and plays much like a physics driven F.E.A.R. game.
Lone Echo and its sequel form a must play astronaut adventure, the free PVP Echo VR/Arena and its $10 Combat DLC rock too.
Red Matter is another sci fi adventure with a different spin than the above and great object and puzzle interactions.
Gadgeteer is a physics-based VR puzzle game where you build chain reaction machines to solve fun, intricate puzzles.
Legendary Tales is a dark fantasy cooperative action RPG that's currently in a very promising early access state.
Karnage Chronicles is a very in depth dungeon crawler with co-op capabilities and precious loot for all involved.
V-Racer Hoverbike is a cool futuristic racer where you can lean to realistically control your jet moto thing.
Guardians VR mixes first person shooting with some tower defense and RTS elements to impressive effect.
Jetborne Racing is a thrilling multiplayer focused flight racing game by the developer of the great VTOL VR.
Hot Dogs, Horseshoes & Hand Grenades or H3VR is basically a gun nut's heaven with all the models you could need and more.
Pixel Ripped is a duo of games with nostalgic trips down retro gaming memory lane in special VR fashion.
Lies Beneath is a meaty and well crafted stylized horror action adventure that immerses, entertains and frightens.
Boneworks is a fully physics driven indie take on Half-Life style shenanigans that many will vouch for.
Sweet Surrender is another FPS roguelite experience with plenty of cool tricks up its stylishly cartoony sleeves.
Paradiddle is a drumming application, it's not 100% realistic but it also takes advantage of VR for things you can't normally do.
VRkshop is a workshop simulator where you can craft the furniture (and more) of your dreams in a very realistic fashion.
Tea for God, like Unseen Diplomacy, is brilliant if you have a few square metres of space to explore its non euclidean environments.
A Township Tale offers social online f2p RPGing/surviving/crafting that's sure to get more fans as it's developed further.
Space Pirate Trainer is a mainstay static wave shooter you might want but personally I've grown past such things, as well as mini game collections like Job or Vacation Simulator which is the reason you don't see many of those in the list (though I had to include various popular rhythm games at least), I prefer more in depth experiences. If you're looking for such games you may want to give them and others like Tower of Doom, Raw Data, Loco Dojo, Rags to Dishes, Cook-Out and Traffic Jams among many others a good look.
There are many more, in early access or similar. ARK-ADE is a visceral FPS with a Tronesque neon look and plenty of content to sink your teeth into, Low-Fi is a Bladerunner style sci fi game with impressive visuals, Crunch Element is a promising procedurally generated co-op romp through destructible enemy compounds, Escape from Mandrillia is a unique asymetric competitive game that seems directly inspired by Alien: Isolation, Bean Stalker is another roguelite with a substantial resource gathering and crafting component to compliment the inventive themes its name suggests, etc. Social playgrounds like Rec Room, VRChat, Bigscreen & NeosVR are also worth a look. VR even has anime visual novels like Altdeus: Beyond Chronos, its expansion Episode Yamato and Spice & Wolf and various titles of the Car Mechanic Simulator, Cooking Simulator and Thief Simulator mould that has become popular in recent times.
Then there are ports of flat games or games that optionally support VR like Skyrim VR, Pulsar: Lost Colony, Phasmophobia, No Man’s Sky, DCS, Elite Dangerous, DiRT Rally, PayDay 2, IL-2 Sturmovik: Battle of Stalingrad, Star Wars: Squadrons, Project Wingman, Rez Infinite, Tetris Effect, War Thunder, American/Euro Truck Simulator 2 (in the beta branches), The Forest and more. Some like Fallout 4 weren’t as well done so caution is necessary, though in this case mods help. Others have been converted by fans. MotherVR is a great VR mod for Alien: Isolation, with gamepad/mkb play like PSVR's Resident Evil 7 (or Subnautica), there's a superb Outer Wilds VR mod and Risk of Rain 2 VR is also great alongside Valheim VR, Quake VR, all the classic Doom engine games and Doom 3, all as good as any native VR games. Naturally, there are also great VR content mods, like ApertureVR for Alyx and Roblox's Cave Explorer 2.
Upcoming titles include Outlier, Gravitational, Frigid VR, Dyschronia, Into the Darkness, Samurai Slaughter House, Runner, System Shock 2, Buccaneers!, Wanderer, Zenith, Undead Citadel, Sushi Ben, Green Hell VR, Captain Toonhead, Firmament, N1NE: The Splintered Mind, Hyperstacks, Vertigo 2, Panther VR, Quantaar, Paradox of Hope, Hubris, Shock Troops, Stress Level Zero's Project 4 & more.
*Facebook acquired the Onward studio, we'll see if they'll properly finish it before moving on to a sequel/future Quest projects.