Unless you are OK with being beholden to Facebook and all of their memes and shit stay away from Oculus. The systems they provide are good, but you have to be fully integrated into the FB/Meta landscape and have no choice. There is no way to just have an oculus account, it has to be tied into your FB account etc. If you are fine with that, then the Q2 is a good cheap option, but just know it does have that issue. As for games and such, 99% of shit works for all the platforms now. There is also a whole bunch of community compatibility mods and patches for systems that will allow them to talk to different game engines even if they were not specifically made to be used by X or Y platform.
As for should you get one? If you have money to spend and are ok with dropping up to 1k go for it, but the game choice isn't amazing right now. IMO VR really excels for rhythm games (beatsaber etc) so if you like those you will have a lot to choose from. But if you are more interested in FPS or "story" games, there is a lot less out there, and some of it can be really janky and not feel good at all.