every game is different. some games the tearing isnt bad at all and also turning vsync on can cause lag especially with triple buffering. just set each game for the best performance and visuals that you want.Don't you hate the tearing without vsync? I've never understood why people dont mind seeing the screen flickering\tearing. Sure there's a higher framerate than 60, but when vsync is on there's no tearing so it looks so much better. Is 60fps not enough?
its best just to do like I said and see what works best for each individual game.Keep in mind if Your video card is fast enough, V-Sync is no big deal. I would leave it always on with tripple buffering enabled, ( Only If your video Card is Above MainStream performance)
But if its not like my self, i always force V-Sync Off.
Many mid-range to high-end setups can run it at 60+ frames. I always have vsync on, as it doesn't effect my performance at all, and keeps it at a steady 60.