From a consumer desktop standpoint, here are some different types.
Brands: Intel, AMD (that's it actually)
Current or Recent Sockets:
Intel: LGA 775, 1156, 1356 upcoming: 1155, 2011
AMD: AM2, AM2+, AM# upcoming: AM3+
If this isn't what you are looking for, let me know.