A Core 2 Extreme X6800 looks like the best supported CPU. You should be able to use any modern graphics card, though at least the faster ones would be held back somewhat by the PCI-Express 1.0 slot on your motherboard.
Realistically, it's time for a motherboard upgrade.