SKS fenders seem to be the industry standard. I've got them on my bike. They look nice, they work, and they're not too heavy.

If you want something really solid, Velo Orange has a full range of metal (aluminum alloy) fenders. Some of them are really pretty.