Unfortunately I can't comment on everquest or HG:london. But Supreme Commander is massivley CPU dependant. It even shows big gains with Quad core CPU's over Dual core. And then you need a pretty hefty GPU on top of that to increase detail levels. And while 1GB ram is decent it does benefit from 2GB too. So I wouldn't expect great performance/smoothness out of that game no matter what GPU you buy. But I wouldn't let that stop you from upgrading from a 9800XT for other games.
Your power supply may or may not be up to the task. How many amps are on the 12v rail? DO you have the exact make & model?
I like the HD2600XT tops for your machine. You would want at least an X1650 pro 128-bit to even consider upgrading from your card. Even that may no be a big enough boost to justify. So you are looking in the $60-120 range anyway. Unfortunately, most of the cards that fall between the HD2600XT and X1650 pro are quite expensive. 7600GT, 7800GS, X1650XT are all too expensive for their price tags so you may as well do the
faster 2600XT. The HD2600 pro is an option too if it's a good savings($40) over the XT.
For any of these, you need to check that power supplies 12v though. A 420W with a single 17 amp 12v rail isn't going to cut it IMO. But if it's got 22 amps or above it should probably power any of these cards. 26 amps or above you are all set.
My suggestions depending on what you want to spend (best to worst)
HD2600XT:
http://www.newegg.com/Product/Product.aspx?Item=N82E16814102718
HD2600 pro:
http://www.newegg.com/Product/Product.aspx?Item=N82E16814102709
X1650 pro:
http://www.newegg.com/Product/Product.aspx?Item=N82E16814161032
http://www.newegg.com/Product/Product.aspx?Item=N82E16814161052