You will have to look at the second hand market for sure, but you can probably get a decent 1080p 80-100fps medium/high build.
Something like (or equivalent):
Ryzen 5 3600
RX 6600
16GB DDR4
1TB SSD (probably not NVMe)
Whatever case
Whatever monitor, even if only 60Hz, for now
Whatever MoBo
Tier A PSU from the Cultists Network PSU tier list
You can most likely get everything used if you buy from a second hand shop that has a form of buyer protection (eBay and similar) and thoroughly check and clean and test everything you buy
I feel the pain: began my Linux journey some four months ago, tried Ubuntu first, played with it a bit for a couple days, abandoned it; then tried PoP!_OS, got it up and running, broke it, wiped it; tried again and it finally clicked! I’m now dailying it, and it’s been pretty good so far!
Keep trying without forcing yourself, maybe try different distros depending on what you need!
I saw W11 in action on a different PC and that made me stay on W10. In the meantime, I researched Linux and dipped my toes in it for a while. Just made PoP! _OS my daily driver (installed on my main NVME), with much less pain than I thought, while I moved W10 on a secondary, old and small SSD, only for those games that don’t work in Proton/Wine.
It is a bit difficult to learn everything from scratch, but it’s a small price to pay, to be honest
Hell yea