I play in D tuning because I like the way it sounds. A good balance between heaviness and tightness of strings.

A lot of bands make really lame use of drop tunings, but it can sound really cool. I think a lot of Pantera's Vulgar Display of Power is in drop D, and sounds heavy as fuck.

__________________