I think some of the problem is that you are thinking that VR is the same game experience you normally have but with a screen on your face. It's not that.
Yes, some games will take a graphical hit but you won't care in most cases. Graphics don't need to be "realistic" or high in detail for VR to work. The two games that are bundled with OR are EVE:V and Lucky’s Tale
https://youtu.be/jqEm1fXBWKg. When you are in VR, it feels like you are there if crafted well. Games like Lucky's Tale may not look impressive on a screen but in a VR headset, a game like Lucky's Tale feels like you're in a cartoon or dream.
Can a VR game benefit from more detail, etc? Of course. If you buy a PSVR and really like it. You can always set a goal of moving to a higher tier(Oculus, Vive, etc). It's a waste to compare a screenshot of a standard game with something in VR because there is a different sense of immersion.
As for scale, You are't going to get a huge open world game like Assassins Creed. Think more along the likes of PT, Shenmue, Resident Evil and cockpit games. VR isn't meant to take the place of other games. You'll have VR games and you'll have your Non-VR games. Best advice I can give is just "TRY IT"(a friend, kiosk at a store) and see if it hits for you. If it doesn't, thats fine. We'll still have AAA console games.