I am a huge proponent of Puzzle games in VR, and my favorite recommendations for VR reflect that: I highly suggest checking out The Room: A Dark Matter and Red Matter (I've heard Red Matter 2 is also very good, but I only have experience with the first one). They're both extremely atmospheric, with the former taking a more gothic victorian vibe and the latter being coldwar scifi. There are aspects to both that might loosely be considered 'horror,' but there aren't any jumpscares that I can recall, it's just occasionally things feel a little creepy or unsettling. Both are native back on Quest 2 so the Quest 3 or 3S should have no issue with them and I'm reasonably certain Red Matter even got a Quest 3-specific fidelity & optimization patch. Both also still appear to be on sale on both the Meta Store and Steam. No multiplayer, unfortunately, but still worth it, imo. If you want a coop puzzler, Rooms of Realities is fun based on what I've played so far, and VRChat & Horizon Worlds both have a variety of escape room worlds you can jump into with friends.
For multiplayer I'm actually a big fan of my most recent VR purchase, Golf +. I've never played golf in my life before, and this game is enough of a sim that that means I have a steep learning curve, but much like when I got into fighting games a year ago, once you start finding your rhythm its extremely rewarding and very fun. For a similar but more forgiving experience, check out Walk About Minigolf. And if you want to add another shooter to your list, the Warhammer40k Battlesister game is far better than I expected it to be. And has coop as well.
And finally, I know you said Quest-native, but there's two suggestions I can't not make. If you get your Quest set up for PCVR, whether via Quest Link, Air Link, Steam Link, Virtual Desktop, whatever method, it's very much worth noting that Elite Dangerous has VR support, and it is exceptionally fun to play like that. But also there is a VR mod for one of my favorite games: Portal 2. The scale is a little off, and playing it in VR might take some getting used to, but playing Chell, GlaDOS, and Wheatley's adventure in virtual reality is one of the best experiences I've had with my own Quest. The video below has more info including a guide on getting it up and running.
https://www.youtube.com/embed/OnFCTqKJP80?feature=oembed