I agree the 460 is a good card and probably suits your needs for price/performance, but a 5850 or 470 is a good upgrade above that, for around $100 more. A single 5850 or 470 can max most games out. Crysis, for example, in DX10 on High with AA (2x or 4x I forget, I think 4x) on a single 5850 ran nicely at 45+ FPS. Tho, now I have 2 5850s and run the game on Very High
Sorry... uh... yeah the 460 is a good card for the price.
On the other hand, AMD Radeon is on the cusp of releasing their 6xxx series. Some rumors say that by mid October we'll see the 6770 which should have the performance of a 460, estimated.