Sorry, I should have specified. I know that playing every game with every setting up full is impractical and, as time goes by, especially with the launch of the new consoles, impossible. I've been buying mid-range cards for most of my pc gaming history, from my Voodoo 3 3000 to my GeForce TI4200, to my Radeon 9800, X800 GTO and onto my 6870. I have always managed to play at mostly the highest settings available, keeping anti-aliasing at 2x and shadows at medium (and no, I can't tell the difference in AA settings in anything above 2x!).
As long as I can set textures to their highest setting, keep most of the rest up to their highest and run at a fair fps (hell, I'm not even picky with fps rates, sub-20 is fine by me in certain games - bound to be a controversial opinion here from what I've seen), all is well and good. The 7970 is a nice upgrade over my 6870 and his 460, and may even last me longer than my usual two year upgrade rate.