PREFERRED WEBSITE(S) FOR PARTS:
PARTS PREFERENCES: "XFX - ATI Radeon HD 4670 1GB DDR2 PCI Express 2.0 Graphics Card"
OVERCLOCKING: I don't think so.
SLI OR CROSSFIRE: N/A
MONITOR RESOLUTION: No idea
ADDITIONAL COMMENTS: He already has plans to upgrade his power supply to 600w.
He is looking to buy a "XFX - ATI Radeon HD 4670 1GB DDR2 PCI Express 2.0 Graphics Card".
I don't know enough to say whether this is a good upgrade or not so I thought I would ask you all Opinions please
Unless it's 1280x1024, it is NOT going to run Napoleon: Total War at full settings. And even then it's very unlikely. It is a low-profile card for a reason.
It's hard to say definitively without knowing what resolution his monitor is, but even a 1600x1200 (or 1600 if he has a small widescreen) card that will meet his desires of MAX settings will set him back ~$100 (Radeon 5770).
However, if his display is low-res, the 4670 should do a... passable job.