Just about anything from Home of the Underdogs (
http://www.the-underdogs.org) is good, though not all of its content is downloadable (only the truly abandonware, no illegal cracks or whatnot).
If your looking for a good 1st person shooter with some cool RPG type twists, check out System Shock 2 while your there.