When you can get complete SFF Ivy Bridge quad-cores (i5-3470) w/8GB DDR3 and a 500GB-1TB HDD, AND Windows, for $100 or occasionally less, in my mind, there's not much reason to go with anything lower-end. YMMV, though, according to budget, and perhaps you like the fixer-up/modding aspect of getting an older Core2-era / Xeon workstation and modding it.
You can also get cheap MT (MiniTower) models, with Sandy/Ivy/Haswell, sometimes as low as $100 as well, though generally not "complete" systems, at that low of a price for the MiniTower models. Expect to drop $30-50 on an SSD, and maybe max out the RAM to 16GB.
There was one I posted for around $230, that was a Haswell MT quad w/SSD + HDD, and 16GB DDR3, that would keep you set for a good while, and you can just drop in a GTX 1650 and make it a somewhat respectable gaming PC.
If OP is not in the USA, though, then I can see taking what one can get for cheap, as prices aren't always as good as they are here, nor surplus PC availability.
Edit: That was really the other problem with those older Core2-era systems, they tended to max out at 8GB of RAM, whereas, I consider that a minimum standard these days, for "ease of computing", and really, if you're a power-user, you'll want 16GB (even on older Sandy/Ivy/Haswell DDR3 platforms), and maybe 32GB on DDR4 platforms like Skylake/Kaby Lake/Coffee Lake.
(I use 32GB, 4x8GB Trident Z RGB RAM in my Ryzen R5 3600 rig these days, and I can't imagine going with anything less. But I'm a bit of a "browser power user".)
Edit: And even for "gaming on the cheap", I would recommend Ivy/Haswell quads, over Core2-era quads, they just have that much more performance. Your min FPS is going to be horrid on Core2-era PCs, even with a quad, IMHO.