Really depends on the game.
For FPS type games, V-Sync is a big no-no for me. Since the camera movement is tied to the mouse, any lag is noticeable and tiring.
Many other games I play with V-Sync, Hollow Knight included. While there's some lag I can get use to it after some time.
Riva Tuner (comes bundled with
Afterburner ) is a freaking awsome tool, one of my favorite functions is the "scanline sync", if you click on the text it shows the "x/2" and "x2" option, wich means you can disable V-Sync and the tool will limit the frames at half or twice the monitor refresh rate. The fine tune number (-8 in the follow screenshot) is used to tune the scanline (if present) to outside off the screen.
Boom, no more tearing at double the frame rate and silk smooth movement.
Linux users have the MangoHud (with the optional GUI flightlessmango) alternative, wich actually works better than RivaTuner itself.