Probably not until the tenth generation. For one there's the lack of a new storage medium, which could serve as a limiting factor (dual-layer Blu-rays hold up to 50GB, while BDXL holds up to 128GB). Of course, it's possible a new commercially available high-capacity storage medium could come about by then. There's already optical discs in development (e.g., HVD) capable of holding over a TB of data.
But the growth of game file sizes over time has been interesting. Some games are just big, while some are artificially big due to lots of FMV/pre-rendered GCI cinematics (this was common on the PS1, and while some modern games do it as well it has become less common, with in-engine cinematics becoming more common). Here's how file sizes have grown over the years:
Super Metroid: 3MB
Super Mario 64: 8MB
Perfect Dark: 32MB
Tomb Raider: 207MB (PSN file size)
Crash Bandicoot: 460MB (PSN file size)
FFVII: 1.29GB (PSN file size; original may have been over 1.4GB as it took up 3 discs)
Halo CE: 2.35GB (Xbox Marketplace file size) or 3.47GB (NTSC disc file size, original Xbox version)
Kingdom Hearts: 2.83GB
GTA San Andreas: 4.2GB (PSN file size)
Halo 3: 5.7GB (Xbox Marketplace and game install sizes)
FFXIII-2: 14.4GB (PS3) or 7.6GB (360)
Max Payne 3: ~15GB
FFXIII: 37.6GB (PS3) or 18.3GB (360)
So, the biggest SNES games were an order of magnitude bigger than the biggest NES games, while the biggest N64 games were another order of magnitude greater than the biggest NES games. The typical single-disc game for the PS1 was several times bigger than the biggest N64 games, but were by definition no greater than 700MB in size, though some of the biggest PS1 games had to be split across two, three, or (rarely) even four discs. The typical PS2 and Xbox game ran between 2 and 4 gigabytes, an order of magnitude larger than most single-disc PS1 games but not considerably larger than the largest PS1 games. Games on the 360 and PS3 had a wide range. Single-disc 360 games were limited by the 8.7GB capacity of a dual-layer DVD, and based on install sizes as well as download sizes the typical major AAA releases ran in the 4-8GB range. Some seventh-gen games ran well over that 8.7GB limit, though, with some tipping the scales at over 30GB. Those that were multiplatform necessitated multiple discs for the 360 version.
For disc-based games, single-disc games grew by two orders of magnitude from the average PS1 game to the average PS4 game. To reach 1TB, they'd have to grow by yet another two orders of magnitude. Given the time it took to go from 500MB to 50GB, it could take a while to pass 1TB. DVDs were still relevant through the seventh generation, but were starting to hit their limits. We're already seeing some PS4 & XBO games hit the 50GB limit for a single dual-layer BD, but better compression could render multiple discs unnecessary for all but the largest games this generation. If BDXL proves to be viable and necessary for gaming purposes, we could see that on next generation consoles. But given the overall growth rate, 1TB games may still be two, maybe even three generations away.