My friend used to use a GTX 460 for years and years (finally snagged him a 2GB model at a reasonable price, and he continued to use that one). Eventually (a few years back), he had me build him a new PC, and I put in a GTX 1050 2GB card, but that GTX 460 had some of the best longevity of any video card in recent mention, as much as the 8800GT(X), or better.
I wouldn't try playing modern 2019-2020 games on one, for one, lack of VRAM, for another, lack of DX12, but for older stuff, sure, plug it in. They had drivers for it up until like April, I think. (Maybe April 2019?) It's Fermi, but it was a special version of Fermi, that was actually super-scalar, in comparison with the rest of the Fermi family. It aged rather well, other than the limited VRAM. (1GB and 768MB were the most common VRAM capacities, but there were a few rare 2GB models too.)
Edit: If this is for gaming, though, try to track down a GTX 970 4GB model (really, 3.5GB, but that's a whole nother can-o-worms to bring up).