It all depends on your budget. If you have the money to put on it, it's definitely worth it. It's a monster and will play everything maxed out at 1080p very well. If it's way over your budget and you were considering making sacrifices just to get it, then no I don't think it is. Go for something like 7870 which is an amazing GPU value right now.
Ok, if you're a hardcore gamer the GTX 680 is the best choice to go with as it's the strongest single GPU out there, followed by HD 7970 if you wanna experience a little difference of FPS in gaming.
Right now the best bang for buck is the HD 7970, you can't get a GTX 680 for $500 and the difference between the 2 cards is 7% @ stock speed, 2 % if you're going to OC the HD 7970.
EDIT: For some games it will be an overkill for that resolution, for some titles like Metro 2033 & Batman AC it's just a strong card can cope up with the demanding games. Something like GTX 580 or HD 7950 play all the games at that resolution very well.
If you can get a 580 for its retail price then it is worth the price, but if you can't find it at the $500 retail price it isn't worth it. Most of the cards are overpriced by $100+ and I don't believe it is worth that much more than a 7970. The 7970 is what I would get and the just overclock the card so that it performs closer to the 680.
The 8800 GTS was the most famous GPU from nVidia as i remember, then the 9800 GX2 landed and it was the first dual GPU in one PCB card was around $700 and it's performance was marvelous but its' not compared to today's games demands and technologies... but it's still a good value for mid range games.
The GTX 690 was introduced yesterday and no one knows what will be revealed the next year or the next months!!