You already tried RE Village, that has the wow factor, as well as CotM, GT7 and Kayak VR. Those are all heavy on motion though, not a good place to start trying it out. I would recommend the Moss/Moss 2 bundle for PSVR. It was already excellent on PSVR, 2nd best next to Astrobot and now looks so much better on PSVR2. It's played sitting, but you can of course stand up to peer into the models at any angle. Easier to control as well, no more jittery moves.
Indeed it's truly amazing how capable the headset is. I also bought the Moss bundle so I think I will really enjoy that too. Especially since Horizon Call of the Mountain is pretty intense.
Please excuse my (probally) poor grammar