Oh, that depends, I've stuck with the GTX 460 up until 2017, if you're willing to drop down settings really low you might get decent framerates. The truth is I've also had a GTX 660 which was far superior in every way and didn't cost that much more at that point.
Yeah you can get away with playing something modern, but it will depend on a game-to-game basis. 2015-2018 AAA games is really stretching the GTX 460, it is especially hurt when you run out of framebuffer (1GB of VRAM for most of them). Fallout 4 as an example runs like hot garbage on it, Skyrim LE without too many mods will be okay. Having a GTX 660 2GB here helps a lot. Some of the newer games really benefit from newer GPU architectural changes which makes Maxwell/Pascal cards wayyyy faster in some scenarios. I'm trying to set the stage on whereabouts the GTX 460 sits, so you can get a general idea.
I remember being able to play Wolfenstein: New Order on the GTX 460 768MB variant, but I would get some stutters here and there, it would still be playable though. BioShock Infinite ran okay for the most part with 900p, CS:GO can almost run on a potato. Final Fantasy 13 PC port can be run okay as far as I know. Resident Evil 5/Devil May Cry 4 runs great at almost max. And you can always run older games at higher resolutions/settings if you know a game you can get into and don't care that much about graphics. I think 2009-2012 triple-A titles are the sweet-spot for it, otherwise as I've said you will have to drop settings in order to reach a reasonable framerate.
Paired with a Sandy/Ivy bridge or even Haswell CPU it should be a decent rig, compared to what you have in your specs right now
Looking back on it, I still think its a good card, it was one of my first proper gaming cards when I finally moved to the mid-range, before I just couldn't afford a card like this.