Opterons are for professional systems (servers, high powered content creation machines, supercomputers) that can be used in multiprocessor arrays, and are much more expensive than Athlons. Athlons are consumer level chips for home pc's (includes sempron, Athlon64, Athlon64 FX and Athlon X2 dual-core series'). If you are looking for a home pc, stick with the Athlon line...
Another note, the Opteron and Athlon chips will not work in the same motherboard, as the opteron has an extra pin for error checking ram.