I don't think there's anything out there now that doesn't require a mostly on internet connection. I will say that I just got an Oculus Quest 2, and I'm in love with it. My PSVR was great but this is leaps and bounds better as a standalone headset. It's also the cheapest entrypoint at $299 for the 128GB, which I personally think has plenty of space. Most of the games/apps I'm downloading are 2GB max, most mostly around 1GB.
Also you can definitely get past the initial motion sickness if that happens. VR is absolutely a game changing experience.
I've had 3 mind-blowing, stand-out, gaming moments in my life:
1. Seeing an NES for the first time as a small kid, a neighbor was playing Super Mario Bros. on it.
2. Playing a demo kiosk at Toys R Us in 1996, showing off Super Mario 64.
3. Playing VR at my friends house. I couldn't stop thinking about it for months.
VR is amazing, I highly recommend it.