Comparing a mid range card to a high end card there really isn't much of a comparison factor. While typically you can compare like this gens mid end to last gens high end (doesn't work in this case) but right there is at least a 2.5-3x performance increase since the 2600XT really was a crippled card IMO.
Besides the fact the 3000's fix issues that where problems in the 2000's line anyways. Overall good choice expecially looking at the price. Of course if you can wait til ATI releases there new cards this summer, price drops and possibly better deal on the new gens mid range or low end high range cards might be in order, but thats waiting til then which might not be viable option.
Surely playing at 1600x1200 is pushing it with the 2600XT by alot. Really recommending at least a 3850, if not possibly the 3870 might be the best option in this case, or possibly the 8800GT/8800GTS.
BTW EVE should have no issues with the card, won't have all the features but shouldn't be an issue for game play. WOW same, LOTR will have to use mid settings. For RTS, Supreme Commander yes could be issues even with lower settings, Sins of a Solar Empire should have zero issues.