Cpu is all about fps.
Gpu is all about eye-candy.
With a 1080p/60Hz monitor, fps isn't much of an issue in most games, only the intense AAA titles or high drop server mmorpgs like WoW will rally tax an older cpu.
For gaming, a 2060 is very similar to a 1070, which is very similar to a 980ti. So a decent upgrade from a 970, but not any giant leaps. One of the bigger points in favor is the vram, the 970 had 4Gb but only 3.5Gb of that was actually high speed ram, so can suffer with more modern games that can use 5-6Gb easily. There's also DLSS, which can greatly improve fps, depending on the title, as the gpu takes on direct renders of some files, bypassing the cpu.
So for $200, it's a bonus. Don't be scared to turn up the graphics settings in game, just be careful of the cpu settings, do it manually, don't rely on med-high-ultra presets or that'll affect cpu and gpu fps.