I have used many different DEs. For me, though, lightweight is better. I don't really care about eye candy, I go for speed and usability. My favorite to date is Fluxbox. With some tweaking it can look very cool but it was designed more to be flexible and lightweight.