Pistol Whip remains one of my favourite VR games, I can play it any time, and on Hard in particular it will definitely get you sweating as you have to duck and dodge extensively. You get better scores by shooting in time with the rhythm, so it ends up being supremely satisfying. On Easy and Medium it’s just a great game.
I’ve not played most of the rest. Racket: Nx I found less satisfying that I hoped it might be, I had enough tracking problems with the Quest that I kinda gave up on it. Synth Riders is good, great even at times, but it doesn’t grab me like Pistol Whip, Beat Saber or Audica. The Climb triggers my vertigo and gets me sweating, but other than holding your arms up for extended periods it’s not that much of a workout, though it is a good game. Walkabout Mini Golf is about as much of a workout as a round of mini golf sounds, but it is brilliant with plenty of content. Thrill of the Fight is the hardest workout of the lot of them, and bundled with Eleven Table Tennis is a great combo.