some of the last XP games that don't work on Modern OS's would include Brothers in Arms Earned in Blood, Road to Hill 30, ect anything with starforce, but it still needs at a minimum for playability an AThlon 64 and a 6800GT, thats old but not that old. Some other games such as Medal of Honor Pacific Assault, Combat Flight Simulator 3, ect aswell don't work or work well on anything newer than XP but these games also required the penacle of hardware from 2005 to run well enough to enjoy. I have an Atlhon XP box setup that I do run older games on, but some of them don't run well at all. Here is the bigger issue, AMD released 13.4 for XP but for some reason left off 7790 support, while Vista/7/8 13.4 has 7790 support, not only that but Intel and Nvidia still support Windows XP, amd is the only vendor to just abandon it, that looks like real poor bussiness sense to me.
AMD FX6300 -- ASROCK 970 Extreme4 -- Diamond HD7790 -- 16gb Patriot DDR3 1600 -- 128gb Sandisk SSD -- 2tb WD Black
AMD Athlon 64 3200 -- MSI K8N Neo FSR -- Saphire X850Pro -- 2gb DDR400 -- Seagate 500GB
AMD Athlon XP 3200 -- ECS KT600A -- PNY Geforce 6600 -- 2gb DDR333 -- WD 80gb
Intel Pentium 4 3.2 -- ECS 845GC -- Diamond 9700Pro -- 1gb DDR333 -- WD 80gb