Has anyone done anything interesting with the various open-sourced games and engines, or is this mainly of historical interest?
The Quake 3 engine is used for fairly well-received open source arena shooters like Tremulous, Xonotic, and Nexuiz.
The Dark Mod is a Doom 3-based Engine for fan-made games in the style of the Thief Series
You also have a few ports of engines to cope with modern windows versions or non-Windows operating systems or just updated gameplay (Jagged Alliance 2 straciatella or 1.13 springs to mind).
https://en.wikipedia.org/wiki/Quake_II_engine#Games_based_on...