Gaming on Linux is absolutely possible, but you have to have the right mindset for it. Put it in its own category. There are games that work on XBOX, there are games that work on PS4, there are Games that work on Windows, there are games that work on Linux. There is significant overlap between all of these, with many games working on all the platforms. Some games work better on some platforms than they do on others.
If you go at this with the mindset that you are going to play all your favorite Windows games on Linux, you will be as disappointied as if you got a PS5 to play Zelda and Animal Crossing. But if you instead go into it with the mindset “this is a gaming platform with thousands of games I can play on it, I’ll play the games that work on this platform” you will find that gaming on Linux is a perfectly adequate gaming platform.
I assume you’ve considered and decided against something like this Frankenstein? https://pcpartpicker.com/list/g6j2Kp