Many gamers are actually very much into tweaking things as you say, from custom PC builds to game mods and other customizations. They see configurability as a benefit, not as a downside. So Linux is a natural fit.
Besides, Linux gaming is quite accessible today without any extensive manual tweaking (while you can always do that if you want to, a lot more than on Windows).