It's suggested more than it helps, especially on MS support pages, but for sure sfc fixes a particular set of problems. Out of about 16 times I've used it professionally it's solved the issue about 12 or so times. (In 20 years, so damn you for making me feel old) And when it didn't it's usually because the file is also corrupt in dllcache.
Chkdsk is/was useful, imho, if you run it with the /r parameter. In my experience it became irrelevant for user systems with ssd's.
Both are tools. Don't blame the tool for being used for something they're not meant for. You could technically use a power drill to hit nails in a wall, sometimes, but someone suggesting a power drill in place of a hammer doesn't mean it's a bad tool.
How is CS2 working on it? I know I could just try to get it running myself on a spare pc, but I find that as I get older I dislike fiddling with things like this more and more. And while I'm fine with just playing games made to work properly on Linux, CS2 and it's predecessors is something me and my real life friends have been playing for nearly two decades. It's a way to keep in touch as everyone has kids and can't come to the pub during the weekend.