To put in simple terms without going into an miga history.
The Amiga 500 is the most compatible for old games.
There were games made later on that will not be compatible for one reason or another. Yes there is still a few new games coming out to this day for the Amiga. Quake II is the last one I can think of.
When looking for games for your Amiga 500 most of them will say "For Amiga 1000 500 2000", but some may say "For OCS/ECS".
-Edit-
By the way, welcome to Amiga.org!! I hope you enjoy your stay:-)