Superhot is the absolute best IMO. If you're open to homebrew, VRigade on SideQuest is my favorite game on the platform, hands down.
One of the first games I tried with the Quest was "The Exorcist" which was pretty creepy and really showcases the immersiveness of VR. You really feel like you're there in that game, which was not always a good thing.
Unpopular opinion, but personally I don't really like Beat Saber (yes, partially because I suck at it). It feels too casual and very repetitive, which I don't feel demonstrates VR's potential. Too much like fruit ninja but for VR.
Outside of games (you can use Oculus for more than games!), I'd also check out Immersed VR. I don't think it's there yet, but the idea has a lot of potential. Very innovative app.
Beatsaber and Superhot are cool games, but they aren't 460€ cool.
With an appropriate USB-C cable[1], Quest has access to the Steam and Oculus PC library too :D
[1] As I’m sure most people on HN already know, there are many different types of USB-C cable, each supporting different subsets of USB-C’s potential functionality...
But it's not jaw dropping.
It's like para para or dance dance revolution, but a bit more imersive.
If you are into puzzle-light exploration in a beautiful space, I would highly recommend Fujii as a hidden gem. The only drawback is that it's pretty short.
Not really "content", but if you are interested in productivity apps, Immersed or BigScreen are among the options for streaming your desktop to your headset, depending on what platform you're on. They can also be used for online VR screensharing. (Disclosure: I have a small stake in Immersed.)
The various streaming apps (Netflix, Amazon Prime Video, Youtube, etc.) are not exactly novel, but I like being able to watch stuff without being in front of the computer. (I finally have the screen on the ceiling that I've always wanted.)