Then you arent going to be using gsync at all, as that still limits the fps to 144, if you want 300fps regardless of any other factor then you want vsync off
But for people who dont like tearing or stutter, gsync is a massive improvement over vsync
Ive never even played CSGO so i really couldnt care less
Don't think I'd say massive, but it's an improvement for sure.