I suspect in certain games, at certain screen resolutions, with certain settings, on busy servers with lots of players, your CPU will see 100% usage before the GPU does, yes.
But the performance difference between the GTX 1060 3GB and GTX 1070 8GB is large. So yes, in most cases, the upgrade is worth it.