Opteron = Server CPU... Socket 940... supports dual channel memory but doesn't support DDR400, only DDR333 and DDR266... has 3 Hyper-Transport links... passed validation to be a server CPU... 128k L1 cache, 1 MB L2 cache
Athlon-64 FX = enthusiast CPU... currently socket 940 just like the Opteron (but will be switching to socket 939 soon)... support dual channel memory up to DDR400... has 3 Hyper Transport links... has not gone through the validation necessary to be a server CPU, but is basically the same as the Opteron... 128k L1 cache, 1 MB L2 cache
Athlon-64 = "value" 64 bit CPU... currently socket 754... does not support dual channel memory (yet, but probably will early next year), but does support DDR400... has a single Hyper Transport link (no multi-cpu capabilities)... not designed to be a server CPU... 128k L1 cache, 1 MB L2 cache
AthlonXP = demoted to the value line (duron status)... socket 462 currently... dual channel and memory speed depend on motherboard... also not a server CPU... 128k L1 cache, Bartons have 512k L2 cache, all others have 256k L2 cache
*EDIT* I typed this up pretty fast just off the top of my head... if I made an error somewhere somebody please correct me.