Games

It really depends how the release turns out. Eye tracking is often used in social VR games like VRChat, and it can help increase peformance, but that often requires setup. The other "features" are not standard or completely lacking in PC VR, like "headset feedback" or adaptive triggers. These wouldn't be used in any games even if the hardware/software was capable of it.

Compared to the Valve Index, the PSVR2 has a higher screen resolution, OLED, no finger tracking (different controllers), and inside-out tracking instead of base station tracking. It looks like a really good option, at a really good price (compared to other "consumer" PC VR headets like the Index). From what I can tell, you're not really "missing" any major hardware features when using PSVR2 on a PC compared to an Index (depends on implementation, will be obvious at release). Although the lack of eye tracking when the hardware is capable is kind of a bummer.

Wait this one out for initial reviews, but if those are good, the PSVR2 seems like a very good option for PC VR (Although only "casual", like playing games, social vr, etc. compared to "competitive" like very high level play at Beat Saber, shooters, etc).

Do note that this is just looking at PC VR exclusive headsets. "Standalone" headsets like the Meta Quest lineup offer similar VR hardware specs at a similar or lower cost. These come with the downside of having to "stream" from a PC rather than using raw display output (for games not natively supported on the headset). The privacy aspect of standalone headsets needs to be considered too. Most run a version of Android, which comes with just as much (or more) telemetry as an average Android smartphone.

As for being tethered, you get used to it pretty quickly. The main problem is that the cable is being used, and will break after some time. They are often expensive to replace, like on the Index. With standalone headsets, the cable is often USB-C and a lot cheaper to replace. I don't know how replacement cables for the PSVR2 are handled.