I have no personal issue with older hardware. I have computers and gaming consoles that are older than I am! You wouldn't believe some of the old tech that I keep around my place.
Here is the thing: I've never physically owned a RX 460, but from what I've read, it would be a lateral upgrade from a 750 Ti. The RX 470 would be a worth while upgrade, except the 4 GB version is sold out in most places ($200 USD) and only the 8 GB version is obtainable ($250). And for the price of $250 - $260, the best purchase is a Nvidia GTX 1060.
Three issues with the GTX 1060, but they are easily surmountable: (1) It will bottleneck your Core2 Extreme X9650, but who cares. Bottlenecking is not a horrible condition. It simply means that there is an imbalance of performance between different components; in this case the CPU and GPU. You will not get the full performance out of the GTX 1060 with that CPU, but that is the price we pay when using older hardware. Not a big deal. (2) Your power supply doesn't have a six pin PCIe power connector. The EVGA GTX 1060 SC Gaming, that I just purchased, has a 6 pin PCIe connector. But it also came with a two 4 pin molex-to- one 6 pin adapter. Since this GTX 1060 has an official 400 watt power supply recommendation, you should be fine as long as you have two available 4 pin power connectors. TDP is 120 watts. (3) Fortunately your motherboard's PCIe 2.0 x16 slot is physically and logically compatible with this newer PCIe 3.0 graphics card. What I don't know is if your motherboard's chipset and BIOS are compatible as well. I recommend updating your motherboard's BIOS and chipset to the latest versions. I also suggest that you purchase the EVGA GTX 1060 SC (or whatever brand & model you prefer) from a site that has a no-hassle return policy. Amazon has the simplest return policy, but I've also had very good experiences with NewEgg.
A GTX 1060 is approximately 3.5 - 4.0 times the performance of the 750 Ti. This figure of mine only applies to systems where the CPU will not bottleneck the GPU. But even knowing that, it should still be a noticeable improvement. Add to that, you can migrate the GPU to a newer system, if you ever care to upgrade years in the future.