My son's birthday just passed, so our home now has a PSVR 2. I only tried it out for about 2 minutes to set it up, so the majority of this is coming from watching the kids play.
Comfort is pretty good. We're limiting them to 15 minutes of play sessions to help stave off motion sickness and headaches. Kids haven't complained, but my brother in law was trying the Star Wars game for about half an hour, and felt off after that. Our kids are still under the Sony recommended age of 12yo (they're 7 and 9), but we asked our optometrist who said just to time limit and have long breaks in between.
Fav games have been Cosmonious High and Synth Riders. Both our kids like the sandbox style of Cosmonious, but our 7yo really likes Synth Riders. He's just biding his time until Beat Saber gets ported.
REZ and Tetris Effect have PSVR2 upgrades, which I've bought, but haven't personally tried. I'm going to try those out tonight after work, if there's time.
SW: Tales from Galaxy's Edge looked fine, but fiddly. Teleport mode for travel seems to be the way to go.
Drums Rock is a "air drum" Rock Band game. Fine, but doesn't compare with actual drum kit games.
The cable has both been a hindrance and a non-issue. We found out early on that pets need to be controlled, or they'll get in the way and be a hazard. I bought a USB-C extension cable, which is only rated for 5Gbps vs the port's standard 10Gbps, but I don't think it has caused any issues. I also didn't opt for the official $50 controller charging station, and went with a third party one for $20. Works well, and has a stand for the headset.
Overall, it's very expensive, but the tech is cool. We're only playing mostly stationary games, so no need to fully dedicate a room to the thing. We've also been keeping a handler in the room whenever the kids play, both for time and for safety, but they haven't been going wild when it's on.