I’ve got 11 different Linux distros installed on several computers around my office, and the most over all usable ones have the KDE 3.5 front end. Some folks prefer Gnome or XFCE, but after fiddling with just about all of the mainstream distros I settled on openSuse 10.2 with the KDE 3.5 front end.