My Athlon 64 3400+ is going to be retired only if motherboard fails as I have no spare with pcie. I have a couple of GeForce GTX 260 so a failing GPU isn't going to lead to retirement. GPU is the most frequently failing component.
As for games which can be played on it - Rise of Nations (2003), Sims 2 (2004), Battlefield 2 (2005), Need for Speed Most Wanted (2005), Quake 4 (2005), Silent Hunter 3 (2005), Civilization 4 (2005), IL-2 Sturmovik: 1946 (2006), Fifa 2007, Nhl 2007, Chessmaster: Grandmaster Edition (2007), Europa Universalis 3 (2007). It isn't for Crysis or Far Cry 2.
I recently bought a little 4x4cm fan Noctua NF-A4x20 FLX to cool the nForce4 chipset. It is quiet even at 5000 rpm. The heatsink was too wobbly so I took the motherboard out and replaced the chipset thermal pad which was heavily deformed with a thicker one and used push pins instead of screws with rubber (helped to avoid too much pressure, but caused wobble in time).
I would not bank on GeForce 5900xt surviving long. In 10 years they will probably be gone even from Vogons.
Pentium III 900E,ECS P6BXT-A+,384MB,GeForce FX 5600, Voodoo 2,Yamaha SM718
Athlon 64 3400+,Gigabyte GA-K8NE,2GB,GeForce GTX 275,Audigy 2 ZS
Phenom II X4 955,Gigabyte GA-MA770-UD3,8GB,GeForce GTX 780
Phenom II X6 1100,Asus 990FX,32GB,GeForce GTX 980 Ti