Played CS for years too. Mostly 1.6 and then GO. 1.6 with about 100 fps limited on a 800x600 CRT monitor. No tearing on that either way of course.
Now for GO the input lag was a real problem, being used to vsync in non competitive games. So I went with low graphic settings and 200 fps. At that rate I don't see tearing anymore. Borders become too thing and vanish too quickly to be bothered.
However with my system I can only run most of the sims between 60-80 fps for standard multiplayer races (mostly clubraces here at RD).
I am really really bothered by Tearing and stuttering without vsync. Tried fast sync, adaptive vsync, no sync and different fps limits etc etc.
Ended up with standard vsync, prerendered frames to 1 and limiting the fps via riva tuner to 59.97 fps.
Reduced the input lag to barely not noticable but due to little CPU lags I still got the big "showing a frame a second time" stutter caused by vsync.
Went for a gsync monitor last December and all problems are gone. No stutter, no tearing, no input lag, no spikes, nothing.
Different to you, I couldn't play any sim without syncing as I always found the stutter to be extremely annoying, the tearing was okayish though.
I tried this with a 165 Hz Monitor and different fps rates and settings. No matter if I ran 60-70 fps or 120+, it was still stuttering...
Which is why if someone goes with an expensive monitor, I will always strongly recommend using freesync or gsync (or gsync compatible ofc).
Since the Samsung super ultrawides don't seem to always run well in gsync compatible mode, I wanted to mention it.
But if someone is using a standard monitor right now without any syncing, then this isn't a problem at all of course.
I don't want to argue about this btw. I'm just happy for you that you are not as bothered and triggered as me, while being a bit grumpy about myself being a special triggered snowflake