The engine the game is built on seems to be a big factor with V-sync. For example, RDR2 doesn't have a lot of screen tearing with V-sync disabled, but on the other hand, any Ubisoft game ever, the V-sync is atrocious. Ubisoft is so bad that I've actually had screen tearing in Black Flag WITH V-sync turned on. I believe your monitor is also a factor.