At this point, I would recommend upgrading your OS if you want to play new games, developers are starting to drop XP support altogether, and once the new console generation hits with a much larger pool of RAM, you can probably expect 32 bit support to end as well at some point. Microsoft is also pulling the plug on security updates for XP next year, so it might be a good idea to move on in the near future.
There are some games that you can get to work with Windows XP, even if they say they only support Vista or higher, these are games that still have a DirectX 9 codepath, in which case the community around those games may have produced a hack to get the title working in XP, a good example of that would be XCom Enemy Unknown. Hacks for Bioshock Infinite and Assassin's Creed 3 might be available, as they have DirectX 9 codepaths, but I am not certain about that. If you insist on sticking with XP, research your games heavily before buying to make sure you are able to get them to work on your operating system.
Other games will only have DirectX 10 and/or 11 codepaths, and they won't run on XP at all eg. Just Cause 2, Battlefield 3 (and anything else that uses the Frostbite Engine), and Crysis 3,
If you don't want to worry about all of that, most indie games will still support XP, if only because they tend not to use advanced DirectX 10 and 11 features. Just don't expect to be able to play too many of the latest AAA releases if you stay with XP.