You can expect a 40-60% improvement in average frame rates depending on the game. Some games will do worse, some way better.
Also be prepared for the exta heat the second card will be dumping inside your PC. Make sure you have good ventilation via a side mounted fan or a top mounted exhaust, GTX 460's run pretty hot and they'll be dumping 100% of that heat into your box.