The novelty hasn't worn off for me because I don't treat it as a game console. I treat it as a new form factor computer.
I use it daily for HIIT workouts, and I use it to spend time with family and friends who are either far away or busy with life i.e. kids. It's way better than FaceTime or Zoom.
Mostly FitXR since it's competitive and SuperNatural. Both are subscription based, $6/month and $15/month if paid yearly. I tend to end with Thrill of the Fight.
In addition to Beat Saber, you might want to check out games like Until You Fall and SynthRiders.
