These cover all the cases I know of:
Securom 7.x with internet activation (3 or 5 installs depending on the game, Securom driver tracks hardware changes): EA games from mid-2008 onward, starting with Mass Effect. Ubisoft games from late 2008 onward, starting with Far Cry 2. Bioshock used this, but 2K's later games have switched back to the CD check variety.
Securom 7.x with CD checking (unlimited installs, but loads the Securom driver): EA games 2006 to mid-2008. Ubisoft games mid-2006 to 2008. 2K games 2007 onward. The earliest games to use this were FEAR and Serious Sam 2 in late 2005. Some recent games that use this but have other publishers are GRID, Fallout 3 and COD4.
Starforce (CD check, installs a driver): Ubisoft games 2005 to mid-2006. Codemasters and Egosoft games in early 2006. Earlier games of the TrackMania series (the latest TMNF game does not have it). Many of these companies have switched to Securom in the US, but some like Ubisoft still use Starforce in their European versions.
Tages (CD check, installs a driver, 5 installs): I don't know a lot about this system, but it's used in STALKER: Clear Sky.
Unknown: Some pre-2006 Activision games (Doom 3 and Quake 4 mainly) use internet verification of CD keys for singleplayer. Quake 4 detected a hardware change for me, but it doesn't seem to use any third party system or install a driver.
As a general rule for the Securom systems, if you find a game with it, any newer games released by the same publisher will also use it or a newer version of it. The last thing to note is that in most cases, the Steam versions of these games have the same DRM as the retail version, on top of the Steam system.